split activity with excel and website

Hi all,
I have a macro that will connect to a web site and then selecting a few buttons, getting to the correct page and then paste a value from sheet1 in the field, click the button to do a search. Once the page pops up with the results page, I need to manually click on the button (it is somehow impossible to find the correct code for it), after the first button, a popup screen appear where I can select a xlm document to download to a specific folder (would be great if it will remember which one to do), after I press the save button, excel should be again the active one. Once excel is the active one, it should mark the cell it just did copy with yellow, select the cel bellow, copy it and again go to the web page and paste it in the search field.

What kind of code do I need to make excel the active application when I press save for the xml file?

I'm lost on that one and I can't find nowhere an answer ;-(

Thanks and greetings.

Hi all,

Just to give an example how it could work. on the web site: http://databases.about.com/od/tutori...xcelsample.htm
there is a search field and a button to make the search. I would like it to get the first word/s to copy from the range A2 and paste it in the field, follow the link and when the page loads and I click on the link, it will ask me to save it. It could be that on B2 there is the name of the folder that is in Documents where it should be saved in.
once I click the button save, it should go back to excel, copy the next word to look for, past it in the field, push the button and bring me to the page where the link is, and again save it in a folder where the name is on the right cell of the word to look for. it should go back to excel once I have clicked on the dialog box when I click the save button. This way I will have a loop that will go trough all the words in the sheet till it gets to the end.

I think I will be able to make the loop with the use of final row, but the code to make excel take focus after clicking on the dialog save box, that is another story. A plus would be to have the code to put the word in the search box and press the button ;-)

Greetings.

Hi all,

If some one just could tell me how to copy the content of a cell into the already open website, that would be already a start.
I know that when IE is the active window, excel needs to be activated again. I use now the below code to paste the content into the web page, but it starts all from the beginning and I need it to stay on the page and every time I'm back in excel, it should move to the next cell below to copy and again start the pasting on the already open web page.

I guess that with some little help I could make it work.

Please Login or Register  to view this content.

This is the button I can't press with vba. It is a button that actually show a different form on the same page where I can put the text to find and press the button from the above code.

HTML Code: 

HTML Code: 

HTML Code: 

HTML Code: 

This works, but I can't repeat it in a loop

Thank you in advance.

Hi all,

Solved differently, see below link where I found a different way:

http://http://www.excelforum.com/excel-programming-vba-macros/999618-pause-macro-and-show-message-box-to-click-on-it-to-continue-2.html#post3637774