Input Boxes on Web Pages

[Guest]

What is the proper code to get a macro input data from an input box that pops
up into a search query on a web page then click the search button. For
example: I have the webpage pop up automatically to the spot I wish it to
go, which is a search box for model numbers. The user would have to input a
model number. I wish to have an input box pop up for them to type the
number, then have it put that number into the search and continue through
clicking options. End result is a specific report that is downloaded into
excel based on model number. Does that make sense? Any input will be
helpful. Thanks!!!!

 

[meh2030]

What is the proper code to get a macro input data from an input box that pops
up into a search query on a web page then click the search button. For
example: I have the webpage pop up automatically to the spot I wish it to
go, which is a search box for model numbers. The user would have to input a
model number. I wish to have an input box pop up for them to type the
number, then have it put that number into the search and continue through
clicking options. End result is a specific report that is downloaded into
excel based on model number. Does that make sense? Any input will be
helpful. Thanks!!!!

Search for something along the lines of IE Automation. You should get
a lot of hits, but it would be worth your time to read through a
number of the posts, that is if you want to do a lot of IE automation
via Excel.

Matt