View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_96_] ExcelMonkey[_96_] is offline
external usenet poster
 
Posts: 1
Default Close file without saving data

I have a routine where I open a file and make temporary changes to it.
When I close it, I do not want to be prompted to save changes. I d
not want to save the changes. They code I am using looks like this:

Windows(FilenameVar &".xls").Activate
ActiveWindow.Close

How to code it so that I am not prompted for saving?

Thanks

--
Message posted from http://www.ExcelForum.com