Pass a value to a web site search box.

Hi Everyone,

Thanks for letting me join and i would just like to say i am at the start of learning VBA so please be gentle.

My first project i need guidance on is i want to have a macro that when run does the following.

1) copys text string from a consistent specified cell for eg Cell 'C5' to the clipboard
2) loads a website in IE
3) selects the search box
4) Paste copied data from clipboard into search boc and executes the search.

Steps 1 and 2 i think i can do but i am struggling with the selecting the search box part.

When the search is completed it provides a table of data in the web browser.

Later i would like to then interrogate the results in column 1 for a particular number off the originating spreadsheet and return the data that corrosponds to that number from column 4.

Thank you in advance for any guidance and help you may be able to give me on my learning curve.

Steve

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.


Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

Since this is your first post I'll change the title for you.