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