How do I add code that saves an xlsx copy of the entire work book

[TBM]

The following creates a new folder, then saves multiple PDF of specific sheets from that book inside the folder.
I wish for it to save an xlsx copy of the entire book in the same "newy created folder"

Please Login or Register  to view this content.

Currently my work around uses "Call RunSave". Which essentially Calls a code that saves the entire book in a previous folder.
Here is that code

Please Login or Register  to view this content.

Any help would be appreciated

[mehmetcik]

Select the developer tab and start the macro recorder

Save your workbook as .xls, create the new folder if you want as part of the save process

Stop the macro recorder.

Edit the recording and ann it into your code.

[jolivanes]

Change references (file name, path, drive) as required.

Please Login or Register  to view this content.

[TBM]

Greetings mehmetcik

I have used the macro recorder.

The problem I am having is putting it into the above code so that it "saves it in the newly created folder" that the above code already creates.

It works for the PDF copies.

But for some reason I can not add a an xlsx of the entire work book.

Thank you and more help would be appreciated

[TBM]

Greetings jolivanes


I have tried your suggestion

The problem I am having is putting it into the above code so that it "saves it in the newly created folder" that the above code already creates.

It works for the PDF copies.

But for some reason I can not add a an xlsx of the entire work book.

Thank you and more help would be appreciated