Can I get a webpage source using an excel macro?

Steveire

Hi. In python I can do something like

import urllib2
myString = urllib2.urlopen("http://www.boards.ie").read.()
# Manipulate myString and do something useful

I'd want to be able to run an excel macro to get data from a webpage and put it into cells. I can put data into cells easily, but I have searched a lot for info on how to get a page source using an excel macro as easily as in the above example. I think I have a lead in that I need to use wininet.dll or something.

This seems to my mind a very simple problem, but I just can't find a solution or a good reference for this stuff.

Can you help?

FSL

This might help

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_WebQueries.asp

Steveire

It looks useful. But I don't know how to use it.

If it's only a few lines could you show me?

comer_97

try this,

http://support.microsoft.com/?kbid=157482