Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I "re-hook" my worksheet window to my Excel window? Jal Excel Discussion (Misc queries) 1 August 29th 08 10:11 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
In Excel - how to delete new window created from window on tool ba Doug Excel Worksheet Functions 1 April 20th 06 09:22 PM
How do I undo the Excel, Window Menu, New Window command OLDFANG Excel Discussion (Misc queries) 2 March 17th 06 05:31 PM
VBA InternetExplorer ReadyState loop Jason livesay Excel Programming 0 February 20th 04 01:07 AM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"