itsmevic
asked on
Excel 2010: Automation > Save Workbook > Exit Workbook
Hello Experts,
Hopefully this is doable within Excel. We have multiple people that use one workbook off of SharePoint. When you click save, the status bar at the bottom will say, "Uploading to Server". Normal stuff. Okay, so from time-to-time, we'll have someone that forgets to log out of the spreadsheet. This of course locks the spreadsheet out for everyone else. We have to end up creating a copy of that spreadsheet in order to use it. This has happen about 10 times now and my patients is running a little short with it.
Is it possible to create a macro that will save the work after a certain amount of time and then auto-magically exit the spreadsheet. The thing is, I don't want anyone to loose any of the their work, which is why I'd want it to save the spreadsheet before exit. Any help with this is greatly appreciated.
Hopefully this is doable within Excel. We have multiple people that use one workbook off of SharePoint. When you click save, the status bar at the bottom will say, "Uploading to Server". Normal stuff. Okay, so from time-to-time, we'll have someone that forgets to log out of the spreadsheet. This of course locks the spreadsheet out for everyone else. We have to end up creating a copy of that spreadsheet in order to use it. This has happen about 10 times now and my patients is running a little short with it.
Is it possible to create a macro that will save the work after a certain amount of time and then auto-magically exit the spreadsheet. The thing is, I don't want anyone to loose any of the their work, which is why I'd want it to save the spreadsheet before exit. Any help with this is greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 500 points for Roy_Cox's comment #a41525113
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for Roy_Cox's comment #a41525113
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Thank you!
Pleased to help
ASKER