Skip to main content

Posts

Showing posts with the label VBA Get Active Internet Explorer

GetObject Error with Internet Explorer

How to get active Internet Explorer Object using Getobject in VBA Set IEBrowser = GetObject(, "InternetExplorer.Application") Using GetObject for Internet Explorer in VBA throws Runtime error 429 - ActiveX can't create object. The  solution for this is to use ShellWindows Runtime error 429 - ActiveX can't create object - GetObject for Internet Explorer Public Function IENavigate(ByRef IEBrowser) As Boolean Dim theSHD As SHDocVw.ShellWindows Dim IE As SHDocVw.InternetExplorer Dim i As Long Dim bIEFound As Boolean On Error GoTo Err_IE Set theSHD = New SHDocVw.ShellWindows For i = 0 To theSHD.Count - 1 Set IE = theSHD.Item(i) If Not IE Is Nothing Then If InStr(1, IE.LocationURL, "file://", vbTextCompare) = 0 And Len(IE.LocationURL) <> 0 Then If IE.Visible = True Then bIEFound = True: Exit For End If End If Next If bIEFound = True Then Set IEBrowser ...

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Labels

Show more