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

Try:

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

Tim


"rvillanueva" wrote in message
...

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

Tim , i test and works fine. Excellent

Thanks you very much !!!


--
rvillanueva
------------------------------------------------------------------------
rvillanueva's Profile: http://www.excelforum.com/member.php...o&userid=28814
View this thread: http://www.excelforum.com/showthread...hreadid=537515