Workbook_BeforeSave Question Function Question

Hello Experts,

I am using the Workbook_BeforeSave function for the first time. I have it working such that the "work" inside the function gets done, but when I close the Excel workbook, I am prompted to save the file once again, without having made any additional changes to the workbook. My sense is I am doing something fundamentally wrong. Within the Workbook_BeforeSave function, I am also trying to save 2 additional text files besides the Excel workbook. I don't know if this is complicating things or not. Any help would be appreciated. Thanks in advance.

Here is my code.

Please Login or Register  to view this content.

Hi thomasmc,

a. Unrelated to your problem, you should probably change the following to turn events back on and to turn on protection:

Please Login or Register  to view this content.

b. It looks like you close the Workbook somewhere else other than this routine, either through code or manually. You probably need one of the following (which fools Excel into thinking the Workbook has been saved) somewhere in your code, when you are CERTAIN that it is SAFE to close the file without saving:

Please Login or Register  to view this content.

You may also need a global variable to indicate when it is OK to use the .saved construct.


-----------------------------
If you need additional help, please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Lewis

Hi LJMetzger

Thank you for the quick response. I implemented your first suggestion of turning events and protection back on. Good catch.

I also added
ThisWorkbook.Saved = True

right after Exit_Sub. But the behavior is still the same. When I close the Excel workbook, I am prompted to save the file once again, without having made any additional changes. Perhaps the .Saved should be placed somewhere else?

Hi LJMetzger,

I took my own suggestion and moved the .Saved to the very last statement in the Workbook_BeforeSave function. That worked! Now the file saves cleanly without and double save requests. Thank you for all of your help!