VBA to auto save file to a shared location, while leaving the current file open and ready?

[Jimmy110]

I'm wondering if this can be done?

I have an excel file that people input data into. At the end of that data collection period, id like to be able to click a macro and it save the file somewhere, but also leave the current sheet open so it can be used by people to input the next round of data.

Can this be done?

Cheers

 

[gordsky]

What exactly do you mean by "leave it open". Do you want the data already collected to be cleared or remain in the"open" sheet? Sample worksheet would also be useful.

 

[Marc L]

​

Just using the SaveCopyAs method …​

 

[Jimmy110]

What exactly do you mean by "leave it open". Do you want the data already collected to be cleared or remain in the"open" sheet? Sample worksheet would also be useful.

Sorry, I mean I want the sheet to remain open for the next user to input data. So the previous chunk of inputted data gets saved somewhere and the sheet is still there for the next person