How can I change the following string to Save As a .XLSM file?
Please Login or Register to view this content.
How can I change the following string to Save As a .XLSM file?
Please Login or Register to view this content.
Last edited by rhudgins; 08-31-2011 at 01:13 PM.
I am very new to VBA, so my advice may not be the most helpful/easiest to follow.
What I would do in this situation though is just open the save as dialog box.
Then you can save the name as whatever you like, and change the file type just as if you were saving anything else.Please Login or Register to view this content.
Hope this helps!
See Ron de Bruin's article on saveas file types.
http://www.rondebruin.nl/saveas.htm
Thank you both for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks