On Jun 12, 11:28*am, expect_ed <expec...@discussions.microsoft.com>
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!
|
Similar Threads
