PDA

View Full Version : Using Excel to Tab through IE



wildpianist
05-01-2008, 01:04 PM
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
05-01-2008, 01:16 PM
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
06-23-2008, 10:04 PM
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
06-24-2008, 08:51 AM
Have you tried FollowHyperlink?

grichey
06-24-2008, 12:52 PM
Have you also tried just doing a webquery?