"Save File As" with a Macro

[geliseev]

Hello,

What's the VBA code to write if I need my macro-enabled file to ultimately be Saved As a file with an .xlsx extension (rather than the .xlsm extension the macro-enabled file carries) - obviously that will result in the loss of the macro upon saving, but I am not concerned about that since this file will just be a copy of a master template.

Thanks.

 

[freesurf]

try this link:
http://www.rondebruin.nl/saveas.htm

HTH