how stop "do you wnat to save etc.msg

I am using excel 2007 but most of my files are excel 2003. Some of them don't give me the "Do you wnat to save etc.msg" on closing after changes. Some have VBA code (not all exactly the same.) When I delete the code, they still close without the message. Why? When I put the same code in one that does generate the message,,it makes no difference. I am obviously missing something.

My need is that I have and Access 2007 file that exports data to an Excel 2003 file, then imports the results. I need to eliminate the "Do you want to save etc" It is just a real bother for the Access user.

Any help much appreciated.

.
Paste this macro into the ThisWorkbook Module :

Please Login or Register  to view this content.

My 2nd reply, I wonder if I am just getting into the coding incorrectly. I just can't even make a new file that works. Could you please give me the very basic steps. I click on Developer, then Visual Basic, then Insert, then paste in code. Correct? Am I missing something?

.
Yes ...

Click on Developer / Visual Basic / ThisWorkbook (upper left side window).

In the large white colored code window on the right, paste the macro there.

Save the workbook as a Macro_Enabled .xlsm file.

Whenever you close the workbook it will automatically save any changes and close on it's own.

If you don't want to save any changes when the workbook closed make the following changes to the code :

'ThisWorkbook.Save '<--- comment out this line by placing an apostrophe in front of it.

ThisWorkbook.Saved = False '<--- then delete the apostrophe from in front of this line.

I am still stuck. I do not see anywhere on screen " ThisWorkbook" When I click on Developer / Visual Basic /. All I get are a header with choices . I clicked on Insert and got choice of: Procedure, UserForm, Module, Class Module, File..... I inserted the code into Module and also Class Module. No effect. I tried it on my other computer and same. How am I missing ThisWorkBook? Again, thank you- I much appreciate your patience with me.

I forgot to mention. On upper left, when I click on Visual Basic, I get "Microsft Visual Basic-my file's name-[Class1(Code)]. On the example you sent me, ThisWorkbook appears where my file says Class1. Confusing.

Thanks so much. I finally got it. I work a lot with Access, not enough with Excel apparently. Other than messing with numbers, I have never really used it. People have given me files to update, apparently with necessary vba code already set up. Learned a lot in messing with this. You have been very patient. Appreciate it a lot. Thanks again

.
You are welcome. Glad to help and more so that you were able to gain knowledge from the experience.

Cheers.