readystate for an IE window that was not created in Excel

N

Necessitysslave

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top