Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can we use MSHTML with VBA?

Tags:

excel

vba

mshtml

I saw a lot of examples in MSDN on how to use MSHTML in VS. Have anyone known if and how we can use MSHTML and VBA to open web pages?

like image 281
Martin08 Avatar asked Mar 06 '09 15:03

Martin08


1 Answers

In the VBA editor, you go under Tools -> References and add a reference to the Microsoft HTML Object Library [MSHTML.TLB]. Here is a link with an example in VBA.

like image 170
Will Rickards Avatar answered Sep 24 '22 11:09

Will Rickards