sendkeys alternative

[ADAMC]

Hi all.

Thanks in advance for any help

Its difficult to explain as the system is an in house one so here goes...

I have a spreadsheet with a long column of order numbers on (so far so good)
what i want to do is copy this number paste it into a search function in system A and then complete the job by simulating some simple key presses using sendkeys
Ive been having a look at sendkeys and this would work but for the fact the number of tabs on our system is not always the same:
copy the first job number paste it in system A - tab 5 times and hit enter
copy second number paste in system A - Tab 7 times and press enter.
meaning i couldnt run the macro on a loop as the key presses might not be the same (hope this makes sense)

Long story short I need perhaps an alternative to send keys that someone can suggest that i can take away and learn for myself.
Any help or advice on either send keys an alternative or even any websites that might help would be massively appreciated.

Thank you

 

[John_w]

You could try an automation tool like AutoIt or DIY with Windows API functions like keybd_event.