Err.Number 429

G

Guest

The following code worked until I reformatted my HDD.
Now it returns the message "Errror Number: 429" which means
"ActiveX component can't create object or return object (version 97)
I've search this forum and the Knowledge Base but found nothing applicable
Any ideas how to correct this
Thanks

Kevi

Sub test(
Dim IE As Object, HTML As Strin
On Error GoTo ErrorMessag
Set IE = GetObject(, "InternetExplorer.Application"
While IE.busy: DoEvents: Wen
HTML = IE.Document.Documentelement.InnerTex
Cells(1, 1) = HTM
Exit Su
ErrorMessage
Err.Number = MsgBox("Error Number: " & Err.Number
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IE not detected 1
username and password controls 1
VBA fails with Run-time Error 429 "ActiveX component can't create object" 1
Word Automation 3
Run-time error 429 2
Stuck on VBA Web Automation 4
Select drop down menu option using libre-calc macro 0
VBA Problems ... (since windows update?) 14

Top