Suppress QueryTable opening IE

midsession

Board Regular
Joined
Oct 12, 2006
Messages
70
Hi MrExcel

I have a macro that has run with no problems on my XP machine for many months. Since I replaced it with a Vista machine the macro will not execute.

The macro uses QueryTable to retrieve data from a website, paste the table data into a sheet and calculate from there. However under the new setup the macro
- opens and displays the web page for the first query in IE which it did not do previously
- displays a Run Time Error 'The object invoked has disconnected from its clients'

I've asked for help on the error elsewhere, so far without success.
http://www.mrexcel.com/forum/showthread.php?t=374534

So now I am hoping that if I prevent the IE session from starting then the error will not appear.

Now my knowledge of the VBA dev environment is even less than my knowledge of VBA itself, so apologies if it's something straightforward. However I'd appreciate any help you can give me out there. Is it an environment variable that needs setting?

Thanks in advance
midsession
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top