How can we use MSHTML with VBA?

问题:

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?

Thanks.

回答1:

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.