Record a macro when you do this manual and look at the code then


--
Regards Ron de Bruin
http://www.rondebruin.nl


"rvillanueva" wrote in message
...

Hi, i have a macro in xls, but depending from a cell i need to save ths
workbook as xlm file.

I check the xls help and i found the following instruction,

ActiveWorkbook.SaveAsXMLData

but i have an error. Any idea ??

Thanks


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