Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Receiving run-time error only part of the time | Excel Discussion (Misc queries) | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |