Using Excel to Tab through IE

[wildpianist]

Hey guys

I'm basically trying to get Excel to, that when you press the button on the sheet to Alt-TAB to IE then tab to the link, enter, tab enter etc etc

I've tried to use SendKeys "%{TAB}" but that is as far as it gets I add more lines to tab and enter but it seems very temperamental and doesn't want to work at all now, is there any other way to get it to browse to a webpage? Note: I have tried directly going to that page, but its not that simple as javascript is used and I can't get access to the web address

Do I have to use SendKeys? Or is there another way I dont know about?

Thanks for your help

[wildpianist]

what I should have added was when I eventually get to the page I need is to Select All and Copy then get Excel back up and paste into the sheet.

[sebas1102]

what I should have added was when I eventually get to the page I need is to Select All and Copy then get Excel back up and paste into the sheet.

Ive been trying to control IE too but since IE is running in the background, the sendkeys doesnt seem to work..

[mdmackillop]

Have you tried FollowHyperlink?

[grichey]

Have you also tried just doing a webquery?