| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Branching in IE via XL Macro: pt I
Sounds good. Where do I find it?
" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| branching macro | Excel Programming | |||
| Branching Logic after SENDMAIL | Excel Worksheet Functions | |||
| Branching Drop Down Menu | Excel Discussion (Misc queries) | |||
| Branching in a macro | Excel Programming | |||
| Branching Macro | Excel Programming | |||
Hybrid Mode
