Run-time error 429
I have written a macro that makes use of internet
explorer. The following code works properly on my system. However, when I attempt to run the exact same code on a different computer, perhaps with a slightly different version of office (though they are both office 2000) it fails. The error message is: "Run-time Error 429: ActiveX Component Can't Create Object." The code is: Sub import() ' import Macro Dim mybrowser As SHDocVw.InternetExplorer Set mybrowser = GetObject(, "InternetExplorer.Application") ..... The failure occurs when the 'Set mybrowser...' line is executed. Any suggestions would be helpful. |
Run-time error 429
"DM" wrote in message ... I have written a macro that makes use of internet explorer. The following code works properly on my system. However, when I attempt to run the exact same code on a different computer, perhaps with a slightly different version of office (though they are both office 2000) it fails. The error message is: "Run-time Error 429: ActiveX Component Can't Create Object." The code is: Sub import() ' import Macro Dim mybrowser As SHDocVw.InternetExplorer Set mybrowser = GetObject(, "InternetExplorer.Application") .... Check the references on the target machine, either one is missing , set wrongly or its a different browser version. Keith |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com