pulling html from a web site into a string variabl
I am trying to load a web page into a string variable so I can parse it, following the example on page 422 of Excel 2002 VBA Programmers Reference by Bullen et. al.
The authors say I need to install a reference to "Micosoft Internet Controls Object Library" but I can't find that via searching the Microsoft site. Perhaps this has been superceded by a newer method? Can anyone please tell me where I can get this and how to install it, or point me towards its replacement? I need to acquire the web page into a string variable rather than download it to a table in the spreadsheet, since I'm trying to write a function rather than a procedure.
Thanks for any help.