Hooking into Internet Explorer events ?

[Jaafar Tribak]

I am creating a new instance of IE via the CreateObject Function ie: using late binding .

The CreateObject function returns a reference to the newly created IE application through which one can access all the IE Objects, Properties and Methods from our project. So far so good.

Now we regards to automating the IE Events, we could easily achieve the above if we were using Early binding by adding to our project a reference to the IE object library and using the WithEvents keyword.However we don't have a reference to the IE object library so we cannot use WithEvents .

So the question is : How can we hook into the IE events from Excel without first adding a reference to the IE library ??

By extension, I would like to know if there is a way of hooking into other application events such as MsWord,PowerPoint etc without first adding a refenrence to their respective libraries .

Regards.

 

[Legacy 98055]

Applications don't throw events. COM throws the events. If you have Internet Explorer then you have the ability to early bind. The component object model is built into the executable just as it is in Excel. Why are you finding it neccesary to late bind?

 

[Jaafar Tribak]

Applications don't throw events. COM throws the events. If you have Internet Explorer then you have the ability to early bind. The component object model is built into the executable just as it is in Excel. Why are you finding it neccesary to late bind?

Thanks Tom. I am just curious to know if there is a workaround for the purposes of learning . Also, if one was to distribute their project it would be nice to avoid the complier erroring out at the WithEvents dclaration if the IE COM library was missing on the target machine .

Regards.

 

[Legacy 98055]

VbScript has a method to raise events. VbScript cannot early bind so there is a round about way to raise events on late bound references but it has been several years since I have used it. Maybe a search in that direction will lead to something.

 

[Legacy 98055]

If IE is on the target machine then COM is standard in the install. The browser helper objects are COM based so it's integrated into IE.

 

[Jaafar Tribak]

VbScript has a method to raise events. VbScript cannot early bind so there is a round about way to raise events on late bound references but it has been several years since I have used it. Maybe a search in that direction will lead to something.

Yes. I was aleardy looking on how to raise late bound events by WScript . I am just trying to figure out how to get a pointer to the WScript root object so I can then Its CreateObject Method and continue from there.

It would be very interesting to see how/if this can be implemented within Excel !

Regards.

 

[Jaafar Tribak]

Hi Tom.

During my search for how to use VBScript to sink server's events i found this which should work but doesn't !

This runs from a VBS and is supposed to create a new Excel instance and monitor the execl application _SheetChange event.

Dim myExcel,myWorkbook
Set myExcel=WScript.CreateObject("Excel.Application","excel_")
Set myWorkbook=myExcel.Workbooks.Add()
myExcel.Visible=TRUE
myExcel.EnableEvents=TRUE
 
Sub excel_SheetChange(ByVal Sh, ByVal Target)
WScript.Echo "Sheet Change: Sheet=" & Sh.Name & "Range=" & _
 Target.Row & "," & Target.Column
End Sub

Can you shed some light on why this doesn't work. ?

Regards.

 

[Andrew Poulsom]

You may find this interesting:

http://www.dailydoseofexcel.com/archives/2009/08/19/using-vbscript-to-monitor-office-eventsor-not/

 

[Jaafar Tribak]

You may find this interesting:

http://www.dailydoseofexcel.com/archives/2009/08/19/using-vbscript-to-monitor-office-eventsor-not/

Thanks Andrew for the link. Tushar Mehta has already been there and it seems that sinking Office applications events "Excel in particular" via VBS is rather disappointing.

I wonder if there is another way of sinking events other than with the CreateObject/GetObject Methods of VBS. Maybe some COM APIs .

Regards.