Using VBA to save an excel Macro-Enabled Workbook to the current directory

Hello all,

I am working on a template for our sales department and need to save a Macro-enabled Template as a Macro-Enabled Workbook in the current/active directory.

I have a name set 'fname' for the file. Idealy, the rep would be able click the button to save the workbook and it would place a copy in the current directory.

I have tried many iterations of this but am running into issues

Thanks all!

Hi there,

See if the following code gets you moving in the right direction:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

GregM