Hello,

I am writing a small VBA projeact to download financial data.
Basically the code will open a new workbook, paste in some data, and
then close this workbook saving it as a text file. This process is then
in a loop, which eventually will save 7000 files.

The problem I am having is that when each of these files are closed
after they are saved a pop up box comes up asking if I would like to
save the file (although it is already saved). This is therefore causing
difficulties as I am having to press yes or no each time, and this is
defeating the point of the macro.

I there a way or piece of code to stop these boxes from appearing.

Many Thanks, and have a great Christmas

James


---
Message posted from http://www.ExcelForum.com/