Renaming Active.Workbook and saving it without saving Macro

Hi everyone,

This is my first post so please bear with me. I have a workbook that I input data into daily. The workbook "Perform NARS Projection.xlsm" manipulates the data. After I have inputed all the new daily data and my information is updated, I need to save the Active Workbook in my G drive.

Ex: G:\Decision_Support\Doug\NARS\

And I want to save it under the new name NARS Projection 2.0 (mm-dd-yy) with current date WITHOUT the last sheet (which has my macro instructions as well as WITHOUT the workbooks macros.

Currently, I have this code which just saves the workbook under a new name in the necessary file but it saves the last worksheet as well as the macros. I tried changing xlsm to xlsx but it wouldn't allow me (and I have to save it as xlsx).

Please Login or Register  to view this content.

Is there a code I can use to eliminate the last Worksheet and the macros while still saving this to my G drive under the specified name?

Thank you for the help!

I have tried saving it as xlsx. However, an error message comes up each time and says that it won't allow it. The message says:

Run-time error '1004':
This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save As type.

What does this mean? If I need a different code to do what I initially wanted in my intial post, what do I have to change?

Thank you