VBA Button pressing on IE explanation

Question

I have managed to get my code to work, but only by searching the internet and finding something that worked, I don't actually understand why.

Could someone please explain why when I used

Dim IE As New InternetExplorer

trying to press a button gave me the error

Object invoked has disconnected from clients

but using

Dim ie As SHDocVw.InternetExplorer

has worked?

Thank You

Vityata · Accepted Answer · 2017-11-27T09:04:56.147

1

You are trying to do early binding of IE in VBA. Thus, you need to do it like this:

Dim ie As SHDocVw.InternetExplorer or Dim IE As New InternetExplorer, after adding the "Microsoft Internet Controls" library to the project (c:\windows\syswow64\ieframe.dll).

In general, if you want to do late binding, you should do it like this:

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

What is the difference between Early and Late Binding? and my understanding about late and early binding

edited Nov 27 '17 at 09:04

answered Nov 22 '17 at 13:59

Vityata

42,633
8
55
100

1

`Dim ie As New InternetExplorer` `ie.Visible = True` does work – jsotola Nov 23 '17 at 07:18
@jsotola with which library? – Vityata Nov 23 '17 at 08:12
1

win7 ... `Microsoft Internet Controls` ... c:\windows\syswow64\ieframe.dll – jsotola Nov 27 '17 at 05:07

VBA Button pressing on IE explanation

1 Answers1