Save As ... (using macro XLS)
 

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

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

ActiveWorkbook.SaveAsXMLData

but i have an error. Any idea ??

Thank

--
rvillanuev
-----------------------------------------------------------------------
rvillanueva's Profile: http://www.excelforum.com/member.php...fo&userid=2881
View this thread: http://www.excelforum.com/showthread.php?threadid=53746

Save As ... (using macro XLS)
 

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