Automate Excel/Internet Explorer Interaction

[duugg]

Hi all, is it possible for Excel to do this..

1. Paste contents of a cell from Excel into a text field into Internet Explorer, hit tab a certain amount of times in Internet Explorer and hit Enter (to click on the hyperlink).

2. Once the clicked hyperlink goes to the next page, go to the next cell in Excel and copy the contents of that cell.

3. Go back to Internet Explorer, tab a pre-determined amount of times, and paste the contents of the last copy from Excel.

4. Repeat the above steps as many times as needed.

Note that Excel would somehow have to know that the new page (the clicked hyperlink) has been populated in Internet Explorer before it executes the next paste.



Thanks,

duugg

[[email protected]]

I don't think an Excel macro or VBA can work on anything except an Excel file. To interact between Excel and Internet Explorer, you might want to try a scripting utility like Auto Hotkey. http://www.autohotkey.com

[Chippy]

You should be able to do this in VBA with InternetExplorer automation and the HTML Object Library (HTMLDocument object, etc.) to populate fields in a web page in the IE browser and 'click' hyperlinks. Search for the highlighted terms for more information and examples.

[duugg]

Hmm,

Interesting dialog here. I will check into these suggestion. Thanks.