Issue with downloading > 1 Yahoo stock quotes in 2003 Macro

I am using Excel 2003

Hi,
I looked over some of the threads and did not encounter on of this type. I have been working on an Excel Macro that downloads stock quotes from Yahoo each morning at 7AM. Once the download (1 off 12) has been received the macro copies the first row of stock information and pastes it into the worksheet. I have 12 worksheets, and each contains the download for a single stock. The problem arises after the macro finishes the first worksheet, opens the second worksheet and sends the request to Yahoo for the next stock quote. I then receive an error message that the file is open. Yahoo uses the same file name for each extract (table.csv) and there seems to be an issue with excel closing the table.csv before the next file is received from Yahoo. I have tried to add (Application.Wait Now() + TimeValue("00:10:00")) after the table.csv file is closed to delay proceeding to the opening of the next worksheet and requesting the next stocks download, but that did nothing. Does anyone have any ideas?

Thanks in advance for any assistance you may be able to offer.
Don

Here is a sample part of the Macro:

Please Login or Register  to view this content.

Try something like this (not tested).

This loops through each worksheet in the sheets array and runs the code between the For-Next block for each sheet.

Replace ActiveSheet.Name with the 1st worksheet in the DataBase Query and add additional sheet names to the Sheets Array (red).

If there was additional code at the end of your macro after all the sheets have been updated, you will have to include that after the Next ws line.

Please Login or Register  to view this content.