Hi -

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.

regards,
David

hmm, wondering if your a little confused here...
The Microsoft Internet Controls should be in your refernces list by default (shdocvw.dll) - just click on tools in the VBA editor, select references and then scroll down till you see it amongst the microsoft entries..

If your missing it entirely thats a different matter and can be resolved by reinstalling internet explorer 6

Thanks. That did the trick. Sometimes it's so simple...:)