View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RLY RLY is offline
external usenet poster
 
Posts: 7
Default "Do You Want to Save Changes" message window

I'm ending a simple data transfer macro with:

Windows(DwnldName).Activate
Application.CutCopyMode = False
ActiveWindow.Close

However, I still receive that "Do you want to save changes" message window
before the system will close the "source" spreadsheet. Can I add some code to
bypass this step & force the source to close w/o saving?

Thanks, Robert