Branching in IE via XL Macro: pt I

[expect_ed]

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

 

[aidan.heritage]

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!

 

[expect_ed]

Sounds good. Where do I find it?

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!