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

Tom Lavedas
===========

"James Hess" wrote:

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!