How to bypass Excel error message
 

I have a macro that closes all files but everytime that I touch a file, the
Save file message from Excel appears. Is there a way I can bypass this error
and force Excel to close the file without saving it?

Thanks

How to bypass Excel error message
 

You're closing the workbooks in code?

someworkbookvariable.close savechanges:=false 'or true???


matelot wrote:

I have a macro that closes all files but everytime that I touch a file, the
Save file message from Excel appears. Is there a way I can bypass this error
and force Excel to close the file without saving it?

Thanks

--

Dave Peterson

How to bypass Excel error message
 

Dave,
Thanks for the code. It worked exactly without Excel prompting the save
textbox.

"Dave Peterson" wrote:

You're closing the workbooks in code?

someworkbookvariable.close savechanges:=false 'or true???


matelot wrote:

I have a macro that closes all files but everytime that I touch a file, the
Save file message from Excel appears. Is there a way I can bypass this error
and force Excel to close the file without saving it?

Thanks

--

Dave Peterson