mark hansen
Well-known Member
- Joined
- Mar 6, 2006
- Messages
- 534
- Office Version
- 2016
- Platform
- Windows
I have a Excel sheet with employee names and employee numbers. We need to use those numbers to place into our training software to take attendance for a class. The training software is web based and we use IE to run it.
Just before training starts, the instructor will log into the training software and access the specific class and start taking attendance.
I'm searching for a way to select the trainee, copy his employee number, then switch to IE (that will already be at the right place), where they will paste in the employee number.
I've done some searches and most of them have you opening IE, or opening and load a website. We should already be at the location where the employee number is needed.
I guess is would sort of be like a ALT+TAB to bring up a previously active window (but a specific previously active window). I don't think Send keys would be the best way to do this because it may not always be the last opened window.
After the employee number is selected, it would be ideal to ... copy the number --- switch to IE, paste it into the attendance window, and switch back to Excel waiting for the next student. But right now, I'm just hoping to make the switch to IE, so at a minimum, the instructor would CTRL+V to paste and click to add the student to the class. Then select Excel (Task bar, or ALT+TAB)to go back and pick up where they left off.
Appreciate any help.
Thanks,
mark
Just before training starts, the instructor will log into the training software and access the specific class and start taking attendance.
I'm searching for a way to select the trainee, copy his employee number, then switch to IE (that will already be at the right place), where they will paste in the employee number.
I've done some searches and most of them have you opening IE, or opening and load a website. We should already be at the location where the employee number is needed.
I guess is would sort of be like a ALT+TAB to bring up a previously active window (but a specific previously active window). I don't think Send keys would be the best way to do this because it may not always be the last opened window.
After the employee number is selected, it would be ideal to ... copy the number --- switch to IE, paste it into the attendance window, and switch back to Excel waiting for the next student. But right now, I'm just hoping to make the switch to IE, so at a minimum, the instructor would CTRL+V to paste and click to add the student to the class. Then select Excel (Task bar, or ALT+TAB)to go back and pick up where they left off.
Appreciate any help.
Thanks,
mark