save as xlsm workbook

Hi joee74,

Here are a couple of ideas that should point you in the right direction. A workbook is attached with working examples of the following:

...I want it to save the entire workbook as an xlsm.

The following code demonstrates how to 'Save As' different types of Workbooks.

Please Login or Register  to view this content.

secondly, is there a way to change the quotename path, so that the user is selected depending on who is using the excel workbook and it auto saves to the location stated on their desktop, or would I need to change this path for each user?

The path can be changed. A system environment variable can be accessed to identify the user and or his home path. You can create permanent environment variables if needed (but not in Excel, and probably needing administrative privileges). Subfolders must already exist, but they can be created in Excel.

The following accesses all system environment variables:

Please Login or Register  to view this content.

Lewis

Hi Lewis

I can only apologise for the time it has taken for me to respond to you on this. I have been tied up in a different part of the business these past months.

This is exactly what I needed and worked an absolute treat. I cant thank you enough

I'm glad it worked out for you. I'm only too happy to share a solution that can save others time and aggravation.

Lewis