web page object reference

[Guest]

Hi everybody,

I would like to what reference in VBA is required to get web page objects.
Like I want from a macro in Excel, open a webpage and get to one of the link
of this page.
Then, while recording a macro, i will know more about the command for web
pages.

Any advices are interesting.

Thanks

Thierry

 

[Colo[MVP Excel]]

Hi Thierry

Tick Microsoft HTML Object Library from Tools > References of VBE main menu.
Then click View > Object browser. Now you can see MSHTML library in the
Search Result window.
Please have a look at HTMLDocument Class.

or you can also use the Local Window like this.
http://puremis.net/excel/code/006.shtml

Regards,
-Colo