|
Subject:
|
pulling html from a web site into a string variabl
|
|
Posted By:
|
David SF
|
Post Date:
|
12/17/2005 4:48:38 AM
|
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
|
|
Reply By:
|
shattered
|
Reply Date:
|
12/19/2005 9:15:59 AM
|
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
|
|
Reply By:
|
David SF
|
Reply Date:
|
12/19/2005 3:24:59 PM
|
Thanks. That did the trick. Sometimes it's so simple...
|
