web page object reference
 

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

web page object reference
 

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

------------------------------------------------------------------
Masaru Kaji (aka Colo)
Office Systems - Excel MSMVP(2004-2005)
Web site: Colo's Excel Junk Room
http://www.puremis.net/excel/
------------------------------------------------------------------

"Thierry" wrote in message
...
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