runtime error 1004 on web queries

[rbnorth]

I have a spreadsheet I have been using for years that has a VBA macro that
uses web queries to download data on multiple stocks from multiple web
locations. About a week ago I started getting a ‘runtime error 1004 - the
file could not be accessed' after the program has made 4 to 7 web queries.

At first I thought maybe I had changed something in the system or in the
visual basic macro but I’ve run the spreadsheet on multiple computers and
I’ve run older versions of the spreadsheet and they all produce this error. I
can only conclude that the change is a result of a recent Microsoft update!!!
Any ideas or work arounds?

 

[Joel]

find the hyperlink to the webpage and manually go to that webpagge in the
internet explorer. The webpage may havve moved. Second the webpage may
havve changed the format of the data and a modification may be needed to the
macro.

Recently somebody in India had a similar problem posted at this webpage with
a Yahoo Webpage.

 

[rbnorth]

Joel,
Thanks for your post but unfortunately that was the first thing I checked.
The web pages and the tables are still where they are suppose to be. I can
access the pages manually using the same code in the web queries.

 

[Joel]

Then the data format probably changed. I would download the table to the PC
to a file. Then modify program to read file to help debug problem.

 

[NickHK]

There have been some recent posts on web queries failing when the
%USER%\Temporary Internet Files folder (or maybe Temp) becomes clogged.
Try emptying that and see if it helps.

NickHK

 

[Don Guillett]

Feel free to send to me for testing if you like.