How to make excel to close a workbook and not prompt to save changes. (without saving changes)

[Radecki]

Hi there!

With the help I got here, some time ago i created an excel file that I use as a converter for my data.
Some smart macros are converting data that I input into the sheet so it looks the way I need it.
I am using this on a daily basis. Each time I am finished when i am closing the file it prompts to save changes (which is a perfectly normal behavior since I put data in it) and i need to click to "do not save" so it clears out the worksheet (not saving the changes) I would like to skip that part. Is it possible to close file and tell excel not to save changes and skip that prompt?

Rad.

 

[VoG]

Try like this

wb.Saved = True ' marks the file as saved but does not save it
wb.Close savechanges:=False