On Jun 12, 11:28*am, expect_ed
wrote:
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

I have a utility written by someone else and therefore available on
line called LivePrice - it's an application that retrieves data for
share prices. I think that if you find this file and look at the code
(which the programmer has kindly and deliberatly left in clear view)
it might give you some useful ideas!