I have a nice little utility that jumps to a specfic project in a web app by
project number. Fortunately the URL of the web app ends with the project
number so that part was easy, the cell looks like this:

=HYPERLINK('Work Area'!$B$6&C44, C44&" WOs")

B6 calculates the URL from the project number and C44 holds the project
number.

The web app requires a log in. If the app has not timed out the project
window opens but if it has timed out an error window opens, so I then use a
Windows macro program to do the following:

Watch for the IE window that contains the win apps error message
Tab to the Login link, enter
Wait for the Login screen
Tab to the user name field and enter the user name
Tab to the PW field, type the PW and enter
Wait for the win app welcome screen (you are now logged into the app)
Minimize the win app window
Make Excel the active window
Loop back and wait for the next error message

I would like to incorporate these steps into Excel so the utility can be
distributed throughout the company without the need for the Windows macro
program.

1. Can IE be controlled from an Excel macro in this way?
2. What code do I use to check whether the win apps error screen results
from a Hyperlink?

Thanks in advance for any assistance!
ed