Switching from Excel to Internet Explorer

mark hansen

Well-known Member
Joined
Mar 6, 2006
Messages
511
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
1,969
These automation may be developed using the commands made available to vba via the Microsoft Html Object Library, mshtml.tlb
Unfortunately this is mostly a trial-and-error process and it is necessary to access the target url to inspect its html source code and identify the method that can be used to interact.
So if you can publish the web page url and we can get access to it probably something can be developed; otherwise it’s a matter for sorcery
Bye
 

mark hansen

Well-known Member
Joined
Mar 6, 2006
Messages
511
Thanks for your reply, sometimes I think all of this stuff is sorcery. With all of the help I have received on this board, people think I'm Harry Potter.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,220
Messages
5,576,807
Members
412,748
Latest member
MikeyP14
Top