.readyState and DocumentComplete are 2 different approaches, u r free to use whatever suits u. Both would work as good as each other. See attached for the readyState implementation.
Hope your queries are answered.

Try image the data is streaming data and change data information
according to your input edit and enter keys press

If you go to read my thread again, you know better , be reminded
the typing error.
The question is, The webiste is already navigated and just need one time to do it.
And when I enter Product NO m the IE display will change on screen information
according to Product No. and I simulate Click button by Postmessage faster
than the screen information , the popup download  menu will still show
the save filename for the previous edit of product NO. Hope you see my
issue.

It seems DownloadComplete Event is working only on .naviagte or .naviagte2
are activated. If I just need to do one time .navigate it might not help my
problem

The DownloadComplete Event is definitely better than tracking the readystate property. Why not let IE do its work and tell you when the work is done!! (see my first comment... Q2)
Plus, u save a lot of processing there (CPU) by not doing the loop!!!

Yes, Coud you answer this

DownloadComplet Event operation is same as looping .readystate and busy
like as follows ?

.nagviate "www.yahoo.com"
Do unti <> .busy and readystate=READYSTATE_COMPLETE
Doevents
Loop

There.... the WithEvents code now in a class and no code in ThisWorkbook. Is this what u r looking for?

See file attached

SOrry again

Please hep to put  _ducumentCompplete() and WithEvents code
in Class module, others can keep it in modMISC  ebcause
I don't want to test WithEvents in Thisworkbook that might not
simulate my code need , and try it and report error.

Please provide a sample file and suggest (indicating in the code) what u want.

Sorry it si not working if I put the _DocumentComplet in classmodule
and the run code in genernal module. I don't wan't to put it Thisworkbook
since it will open file and running the code.

Please help to put it in modMisc for _ducumentComplet() and
other run code in Moduel1 for testing


Duncan

Here is what u want. Go to the module and run OpenIE(). After google.com opens, msgbox pops.

Your Example is good, but I have to run my code in module, and WithEvents is only on Class, form, Thisworkbook,
and now I know Raise events happen if the name is oIE  with _DownnlaodComple(0
and I try to put it in  oIE_DownloadComplete in Class module  attached as code area but  fail to display
msgbox "DownloadComple Evenet Done", please advise the mistake if possible


Your Code:
Option Explicit

Dim WithEvents oIE As InternetExplorer
Dim oDoc As HTMLDocument
Dim oA As HTMLAnchorElement

Public Sub OpenIE()
Set oIE = New InternetExplorer
oIE.Visible = True
oIE.Navigate "www.google.com"
End Sub

Private Sub oIE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
Set oDoc = pDisp.Document
If InStr(1, URL, "www.google.com/search?") > 0 Then
    oIE.Navigate oDoc.getElementById("ires").Children(0).getElementsByTagName("a")(0).href
ElseIf InStr(1, URL, "www.google.com") > 0 Then
    oDoc.getelementsbyname("q")(0).Value = "Disneyland"
    oDoc.getelementsbyname("btnG")(0).Click
End If
End Sub

'Class Module , name "Class1"Option ExplicitPublic WithEvents oIE As InternetExplorerSub oIE_DownloadComplete()MsgBox "DownloadComplete Event  Done"End Sub'In general module===========================Sub RunMe()Dim myie As Class1  Set myie = New Class1  Set myie.oIE = New InternetExplorer  myie.oIE.Visible = True  myie.oIE.navigate "http://www.hsbc.com.hk/1/2/chinese/home"    End Sub                                          

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:

If downloadComplet Event operation is same as looping .readystate and busy , I think it is hard
to check is product information data coming is completely on IE page or memery.
Why I care this because some file is small some is big and I don't want to add
idle time such as sleep(1000) to wait the data on memory or IE completely that will
increase program download file time.

With myie
.navigate "www.mywebsite.com"
Do until .ready=4 and not busy loop
hdlg=findwindow ("Mywebsite Tile", vbnullstring)
SendMessageSTRING hdlg, WM_SETTEXT, 6, productNo  'Enter Product NO
postmessage hdlg, WM_KeyDown , &HD, vbnullstring   'Data is coming after enter key
Do until .ready=4 and not busy loop   ' Want to check whetter data is on momery and IE display first , How to fix here code ?
Sleep(3000) ' Adding Sleep(3000) It works but total time is increasing a lot about 10 TimesPostMessage(hdlg, WM_LBUTTONDOWN, 0, vbNullString) "Click download button  "The bug is here to display previous productNO information.

Thanks it is really good in detail. Just clarify one more ppint.
If we have no issue to use do loop to do  such as Do unitl .ready=4 and not busy loop that is exactly same function and purpose
for DownloadComplete Event, Right ?

Since I myiE.nagivate one download webiste and the webiste need me to enter product Number  with enter keys and display
the inofrmation on the IE web page first according to my input product number and then I can click one download button
to popup download menu to save the file in PC.  Since I get 300 product files to download, so I want to reduce  total loading time
for automation file download by API function
So I doing a test and I found when enter product key and enter key, and the product NO information is shown on my IE,  
and then disconnect Internet, and I am able to save information into the file. The test is telling me the popup donwload
diaglog is just for save file not related to internet fetch, so I think the issue is display data information in IE webpage.
 
And I think my code as follows has issue since the loop is just checking internet fetech and doesn't
check whether the data is completed on the IE display page and memory so I always click the downlaod button only
save previouse product NO information. That is why I want to find a way to check when the data is ready on IE display
or memory completely . So I goggle the site to find out DownloadComplete for solving the issue.
It seems DownloadComplete event is similar operation as ready state, Right ?

Please advise and go ahead to quick study your material,  Now I Knwo Withevents is only able on Form, Class not module.

Duncan

My Part of Code for fetch data issue
============================================
With myie
.navigate "www.mywebsite.com"
Do until .ready=4 and not busy loop
hdlg=findwindow ("Mywebsite Tile", vbnullstring)
SendMessageSTRING hdlg, WM_SETTEXT, 6, productNo  'Enter Product NO
postmessage hdlg, WM_KeyDown , &HD, vbnullstring   'Data is coming after enter key
Do until .ready=4 and not busy loop   ' Want to check whetter data is on momery and IE display first , How to fix here code ?
PostMessage(hdlg, WM_LBUTTONDOWN, 0, vbNullString) "Click download button  "The bug is here to display previous productNO information.