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
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