Automatically answering no to save request
I'm writing a program where I have one spreadsheet go
through a group of other spreadsheets, opening them one at
a time, grabbing some data, and closing them.
The problem is that when my program closes the files, it
is interupted because Excel will ask me if I want to save
changes to the file I just opened.
Is there a way I can use VBA to
1. Automatically answer no to the "save" question
2. Or, prevent the "save" question in the first place
I could just use VBA to go ahead and save the files, but
that dramatically slows the program down.
Thanks for your help!
|