VBA Excel

[simplypoet]

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.

 

[SkipVought]

hi,

Your code?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[simplypoet]

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

_____________

in the interest of giving all of the information, i am actually wanting to make a script that will copy a cell, paste it in a web form, the search it, then retrieve a piece of information, and paste it back into another cell(A,2)

i have tried many different ways of navigating the web page, including Sendkeys, with no luck.


Thanks!

 

[SkipVought]

I would check out a web query.

Date > get external data > web query.

Turn on your macro recorder and record editing your query.

Play around with the TABLE number and RUN the code. You may find a way to provide the value of interest in the query code parameters. Just a guess.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[simplypoet]

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.