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 websites, 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 the following error before exiting:
Run Time Error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients
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 websites, 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 the following error before exiting:
Run Time Error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients
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