Question: Macro to save and close workbook

[extremecorvette]

Question: Macro to save and close workbook

This is what I have come up with, I have found three issues with it.
1. One it closes all the workbooks I have open and only saves the one that the macro is in.
2. Two if I put this macro in more than one workbook I can’t have both open at the same time.
3. Three I got the missage to come up You have 5 minutes to save before Excel closes. But if no one clicks that message the workbook stays open.

Running Excel 2003 with Windows 7

Please Login or Register  to view this content.

[Mordred]

Hi extremcorvette, Please enclose your code with code tags. To find out how, please click here and read rule # 3.

[extremecorvette]

I set it up to run 2 min and then at 1 min give the warning. It would be nice to get the WsShell.Popup to stay open for 30 sec.



I still need to find a way to only close this one workbook and not all the others I have open. Any ideas?





Here is the code I'm using.

Please Login or Register  to view this content.