Save As ... (using macro XLS)

[rvillanueva]

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

[Ron de Bruin]

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


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


"rvillanueva" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>