SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 738
- Office Version
- 365
- Platform
- Windows
I use this code to give focus then close a file I've been using elsewhere in my macro where changes are made to the file.
Windows("My File.xlsx").Activate
ActiveWorkbook.Close
It works fine but is there a way to make it close the file without prompting me to save changes? I do NOT want to save the changes.
Windows("My File.xlsx").Activate
ActiveWorkbook.Close
It works fine but is there a way to make it close the file without prompting me to save changes? I do NOT want to save the changes.