Need to save a copy of a workbook to another location

[aliciaward1001]

I use a workbook that is updated daily. At the end of the shift, I need to save a copy (with macros intact) to another file location. The name of the file will need to be the contents of cell Y2 on the master document. I also need the master to remain open and not close immediately after saving. I've only been able to find tutorials that save without macros and that close the master immediately after saving.

[Mr.PB]

Please Login or Register  to view this content.

[aliciaward1001]

Close

After I'm finished updating the master document, I need the master to retain the changes I made while saving a copy of the document in a shared file location. Once saved, I need the master to remain open. The copy can just be stored without being open. This does save the file labeled as the contents of cell Y2, however it saves to my own personal documents so I'll need to add the address to the shared file location. It also closes the master without saving the changes and leaves the copy open.

Edit: Maybe nevermind the above. I didnt see the whole thing

[aliciaward1001]

Please Login or Register  to view this content.

This is what I have currently, but it still closes the master without saving and leaves me in the open copied file which it deposits in my documents instead of the designated file.

[Mr.PB]

Try This. You'll need Microsoft Scripting Runtime enabled and be aware that it will overwrite a file of the same name in the save location.

Please Login or Register  to view this content.

[aliciaward1001]

Looks like that's gonna work. Only thing now is that the copied version isn't recognized as an excel document.

[Mr.PB]

Be sure the name of the file in cell Y2 has the file type on the right side of the string (probably .xlsm in your case).

[aliciaward1001]

Works! thanks