Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
readystate for an IE window that was not created in Excel
Hi,
I need to get the readystate for an internet explorer window that my users will have open already: Public Sub testingGettingInfo() Dim ttime As Double Dim ListMan As Long ttime = Timer Do AppActivate "List Manager" Loop Until ttime + 1 / 3 < Timer ListMan = ahtGetActiveWindow SetCursorPos 780, 32 SendLeftClick Do Loop Until {ahh need excel object}.ReadyState = 4 {insert code for getting info from page} Does anyone know the way of doing this? I've been checking the archives but can't find this anywhere. Also I've been unable to find a comprehensive list of functions that you can load into excel from dll's like user32.dll if anyone have got any links to this aswell I'd be greatful |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
VBA InternetExplorer ReadyState loop | Excel Programming |