Hi Mike,

?READYSTATE_COMPLETE
4
?READYSTATE_INTERACTIVE
3
?READYSTATE_LOADED
2
?READYSTATE_LOADING
1
?READYSTATE_UNINITIALIZED
0

I forgot to mention in the previous posts, but if you add a reference to
Microsoft Internet Controls, these constants will be defined for you (as
well as the InternetExplorer class).

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mike wrote:
On Mon, 17 Nov 2003 at 07:59:47, Jake Marx (Jake Marx
) wrote:
Do Until Not ie.Busy And ie.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop

Is it possible to tell me the values and names of all the READYSTATE_
constants. I've tried loading my Office CD-ROM, but it just plays the
windows tune and doesn't bring up the dialogue box

It's just a problem with that CD (or something with Office on my hard
drive) as other software is fine

This would be a big help please