excell+access
New Member
- Joined
- Dec 28, 2006
- Messages
- 17
I have a list of 5 digit numeric serial numbers in column A2:A3000
I have 1 digit alpha code in Column B2:B3000
I need excel to take the 5 digit numeric serial number ->switch over to the WEBAPPLICATION wait 5 seconds, type in the numeric serial number in a certain box, wait 5 seconds move down 5 rows/input boxes take the 1 digit ALPHA code and input that into that WEBAPPLICATION input box, wait 5 seconds move done 5 postions, action the enter or save command, action a Y or YES command to clear a WEBAPPLICATION prompt, go back to Excel update Column C with DONE and repeat for all 3000 rows.
Is that possible?
Hope that makes sense
-Keith
I have 1 digit alpha code in Column B2:B3000
I need excel to take the 5 digit numeric serial number ->switch over to the WEBAPPLICATION wait 5 seconds, type in the numeric serial number in a certain box, wait 5 seconds move down 5 rows/input boxes take the 1 digit ALPHA code and input that into that WEBAPPLICATION input box, wait 5 seconds move done 5 postions, action the enter or save command, action a Y or YES command to clear a WEBAPPLICATION prompt, go back to Excel update Column C with DONE and repeat for all 3000 rows.
Is that possible?
Hope that makes sense
-Keith