error: the object invoked has disconnected from its clients

**cooper1308** · 08-17-2009, 05:34 AM

Pulling a bunch of data from the Yahoo finance website.. Basically the web-query macro re-runs itself once it finishes.... some sort of loop.

I've had various errors but managed to get it working, after around 200 lines of data, I get the error:

"error: the object invoked has disconnected from its clients"

as I result i've had to auto-save everytime the macro executes.

Anyone had any experience with this error or suggestions to fix? Also anything that will speed it up?

When I debug this line is highlighted:

.Refresh BackgroundQuery:=False

Attached is the the file, and the code is below:

Please Login or Register  to view this content.

p.s I have had to clear the cache everytime the web-query executes in order to over-come a previous error.

**Leith Ross** · 08-17-2009, 09:39 PM

Hello cooper1308,

The problem is the recorded macro creates a new QueryTable each stock symbol. After a point, you run out of memory, pointers to variables get mixed up, and you get the error.

This example would need to be modified to work with your data, since I don't know the layout of both pages. I would need to see the workbook to make the appropriate changes. This macro checks if the QueryTable exists or not. If it doesn't exist then it is created. Otherwise, it changes some of the properties and runs the query using the stock symbol in "A1".

Please Login or Register  to view this content.

**cooper1308** · 08-18-2009, 09:14 AM

Ok tried running the above using F8 step by step but wouldn't work.... no data found error)

Maybe because I am switching between 07 and 03 excel...or does that matter?

I have attached the spreadsheet, if you can have a quick look that'd be great.

thanks again!

**Leith Ross** · 08-18-2009, 10:59 AM

Hello Cooper1308,

It may have something to do with switching between 2003 and 2007. Not really a good idea. Whenever possible, develop your solution for version of Excel that your system is running.

I don't have 2007. You will need to save the file in 2003 format. If it works correctly in 2003 then we know it is a conversion problem if it fails in 2007.