Problem with Activeworkbook.Close SaveChanges:=False
My guess would be that the file that seems to fail is not the activeworkbook
when the code is run.
Other than that, I have never seen a problem with that command.
--
Regards,
Tom Ogilvy
"Ron McCormick" wrote:
I have a model that opens files, copies data from the file opened, and is
supposed then to close the file with: Activeworkbook.Close
SaveChanges:=False. It has worked satisfactorily for years but seems to have
stopped working recently, following an update of the files from which the
data is extracted. Any ideas why this might be happening?
TIA
Ron
|