View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default 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