Dear All!

With VBA I want to do all steps below:

Access my Web page using by Internet Explorer
Choose an Item (from list box) inside opening web page and then choose a command button

For example With VBA
1/I want to access web page from Internet Explorer: (http://p2p.wrox.com/forum.asp?FORUM_...sc&whichpage=1)
2/Choose: the last 2 days (from list box at left end of the page above)
3/Choose: Go (from list box at left end of the page above)

Many thanks

NC Hoang

You do need to know the name of the element or it's array number to access it. This code assumes you click a button called CommandButton1:
----------------------------------------------------------------
Private Sub CommandButton1_Click()

'Requires Microsoft Internet Controls reference (Tools > References from code window)
  Dim ieBrowser As InternetExplorer, sSite As String
  sSite = "http://p2p.wrox.com/forum.asp?FORUM_ID=72&sortfield=lastpost&sortorder =desc&whichpage=1"
  Set ieBrowser = CreateObject("InternetExplorer.Application") 'Open IE instance
  ieBrowser.Navigate sSite 'Open page
  ieBrowser.Visible = True
  Do While ieBrowser.ReadyState <> READYSTATE_COMPLETE 'wait for page to load
    DoEvents
  Loop
  ieBrowser.Document.Forms("DaysFilter").Elements("D ays").Value = 2
  ieBrowser.Document.Forms("DaysFilter").Submit

End Sub
----------------------------------------------------------------

Hope this helps point you in the right direction. You can change when the browser is 'visible' or never make it visible. If you don't make it visible make sure to close it in your code.

Hi Allenm !
Your solution is great.
1/How can I get some information that I want (eg. some lines) contained in a webpage.
2/Can We read all page and store it in a variable.
3/How to use Mozilla Firefox (in new tab when it is opened) instead of Internet Explorer to open webpage

Regards

1) You would have to know the object name to pull from (document.name/id.innerHTML) or parse it yourself from the whole page/section based on tag(s).

2) Try either ieBrowser.Document.Body.innerTEXT or ieBrowser.Document.Body.innerHTML if you wish to preserve the tags.

3) Sadly you can't instantiate Mozilla Firefox with Microsoft VBA, only Microsoft IE. It should be clear why. You can, if you wish to deal with windows/handlers and their idiosyncrasies, use in combination the Shell command, passkeys and timeouts to grab body content. It's just not as convenient nor can you be specific as to what gets 'grabbed' but that means you can't do anything else while the computer is doing this or it won't work. It also can be buggy since you can't explicitly detect when the page is done.

Does this answer the question(s)?

Thank for your kindly help. I try it now.

Great, it's the answer i'm looking for.

 Hi Allenm !
Please advise me some following questions.

1/How can I reload a opening page (open with ieBrowser.Navigate sSite code) every 5 seconds to get latest information by VBA.
2/How to close a opening page.
3/Please advise a web_page that teach VBA code complied with internet explorer

Regards.

Hi!

Can we know a page load successfully or have an error when loading? Is there any parameter to make VBA detect a page loads with error

Thanks.