Save copy file only when saving file as xlsm

[Sam Longstaff]

Hi,

I have a workbook that is saved as an xlsm but is also saved as a .mht (to publish the workbook). I routinely save the file as .xlsm (this is the master copy) and then as .mht before exiting.

I would like a VBA script that automatically saves a copy of the file in a separate location as .xlsm whenever I save the file as .xlsm. I don't want the script to create a copy when I save it as .mht version.

Is this possible?

Thank you.

 

[Marc L]

Hi !​

​

Yes, just using the SaveCopyAs method as you can check within VBA help …​

​

 

[Sam Longstaff]

HI Marc,

I'm really pretty clueless, where do I find the VBA help?

 

[Marc L]

On VBE side (Alt F11) via icon, menu or F1 key …​

​