Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
Need a save as macro | Excel Programming | |||
ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
Prompted to save changes after macro save - why? | Excel Programming |