View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Hess James Hess is offline
external usenet poster
 
Posts: 1
Default 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!