Typing in another program

Hi everyone,
I know how to open up another program through Excel, but is there a way to get it to type in the other program? Say I was going to gmail. This page opens up with the cursor in the username box. Is there a way to type "username" in that box, tab once to the password box, then enter "password"?

Thanks,
Will

Hello Will,

Here is macro to log on to Gmail with Internet Explorer. You will need to set a reference to Microsoft Internet Controls in your VBA project for this to run. Place this macro in a Standard VBA module. Change the UserName, your email name, and password as well before running it.

Please Login or Register  to view this content.

Setting the needed Reference
1) If you are in Excel, press ALT+F11 to activate the [b]VBE{/b]
2) Click on Tools
3) Click on References...
4) Scroll through the References list using the Down Arrow. The list is in alphabetical order.
5) Look for Microsoft Internet Controls
6) When you find it, press the Space Bar to select it.
7) Press Enter to exit.
8) Press CTRL+S to Save the reference in your project.

Sincerely,
Leith Ross

Thank you very much! Works great!