Save as XML File msg !! (Macros)

[rvillanueva]

I have a xls file with a macro, when i run the macro and i open another xls file and i need to save as xls file and xml file.

i try to save as xml file, but always a msg box appear to tell me that the xml file was save w/o the vb project (macros) i need to click yes.

Theres an auto way to do that using macros of course.

ActiveWorkbook.SaveAs Filename:=LogDia, FileFormat:=xlXMLSpreadsheet, ReadOnlyRecommended:=True

any idea ??

Thanks
Ricardo

[Tim Williams]

Try:

Application.Displayalerts = False
'save
Application.Displayalerts = True

Tim


"rvillanueva" <rvillanueva.271rsa_1146350102.1292@excelforum-nospam.com> wrote in message
news:rvillanueva.271rsa_1146350102.1292@excelforum-nospam.com...
>
> I have a xls file with a macro, when i run the macro and i open another
> xls file and i need to save as xls file and xml file.
>
> i try to save as xml file, but always a msg box appear to tell me that
> the xml file was save w/o the vb project (macros) i need to click yes.
>
> Theres an auto way to do that using macros of course.
>
> ActiveWorkbook.SaveAs Filename:=LogDia, FileFormat:=xlXMLSpreadsheet,
> ReadOnlyRecommended:=True
>
> any idea ??
>
> Thanks
> Ricardo
>
>
> --
> rvillanueva
> ------------------------------------------------------------------------
> rvillanueva's Profile: http://www.excelforum.com/member.php...o&userid=28814
> View this thread: http://www.excelforum.com/showthread...hreadid=537515
>

[rvillanueva]

Tim , i test and works fine. Excellent

Thanks you very much !!!