i had tried that for a while, but the information that i need to copy from the web page does not have the yellow arrow next to it, so i didnt know how to copy a random field on the page.
im really starting from scratch here.. with not a lot of background in vbscript.
____________
Sub internet1()
ActiveCell(A, 1).Copy
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "http://phone.company.net/phone/phonebook.htm#"
IE.Visible = True
End Sub
_____________...
i am trying to create a script that will select information from an internet page, and paste it into an excel doc. So far, my script will only open the web page, but i cannot access the fields at which i need to copy the information.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.