J
James Rose
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
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