Automatically answering no to save request

J

James Hess

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!
 
T

Tom Lavedas

Yes, set the WorkBook.Saved property = True before your use Workbook.Close.

Tom Lavedas
===========
 
J

James

Excellent, thank you. It worked with slight exception

I used "ActiveWorkbook.Saved = True" vs 'Workbook.Saved =
True"
 
Top