View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
matelot matelot is offline
external usenet poster
 
Posts: 72
Default 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