Hi All,
I have a sub routine that closes a file automatically (see below). At the moment, it is coming up with the message that prompts the user to save changes or not. I don't want this message to appear, but simply for the file to close in the background without any changes being saved.
Can this be done?
Sub closeOrigFile()
' close the original file without saving
Windows(origFilename).Activate
ActiveWorkbook.Close
End Sub
Cheers, :cheers: