Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Can I get a webpage source using an excel macro?

  • 19-06-2006 8:48pm
    #1
    Steveire
    Registered Users, Registered Users 2 Posts: 1,421 ✭✭✭


    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?


Comments

Advertisement