Hi all, first time poster here.
I'll preface this by saying I know nothing about VB, though I've done a few years of programming in various languages.
My problem is relatively simple - I have a column of URLs in excel, and I wish to go through each one and retrieve the email address located on the page and spit that back into my excel sheet. I tried using a web query but I couldn't import the table containing the email - it would only grab the whole page 'skeleton', MINUS the actual information.
I figured the next alternative would be to use a VB script. I have spent maybe 3-4 hours trying to hack examples from the web into shape, but none of my attempts have worked.
A sample URI I need to visit is: http://www.minedu.govt.nz/Parents/Al...ngton%20School
The label id I need is: span id="ctl21_ctl13_ctl00_lblEmail"
Basically, I've tried things likeor .text etc, but none of them worked. If someone could help me out I would really appreciate it =)![]()
Please Login or Register to view this content.
Bookmarks