I am not sure if this is the right place to ask the question but I would like to read information from Internet Explorer into a Microsoft Access database and have no idea how to go about it. Would anyone please be able to help by pointing me in the right direction?

My problem is as follows: Some sales figures are published on a web site. These figures are needed by my database so I can do some statistics on the data. It would be nice if I could read the data directly from the website into the database instead of having to log on, read the numbers from the web page, and type them into a form by hand.

Is this at all possible? If so, how do I achieve my goal?

Any help will be much appreciated.

Astrid Van Maanen

From the VBA Editor:
1) Click Tools > References
2) Place check next to Microsoft Internet Controls
3) Click Okay

The code then would resemble:
-------------------------------------------------
Private Function RetrieveSite(sSite As String) As String 'sSite you pass is the desired site. Example: HTTP:/YourSite.com

'Attempts to retreive website content and returns content
  Dim ieBrowser As InternetExplorer
  Set ieBrowser = CreateObject("InternetExplorer.Application")
  ieBrowser.Navigate sSite
  ieBrowser.Visible = True 'Remove this line if you don't want to see the browser window
  Do While ieBrowser.ReadyState <> READYSTATE_COMPLETE 'Code waits for instanciated browser instance to finish loading page
    DoEvents
  Loop
  RetrieveSite = ieBrowser.Document.Body.innerTEXT 'Return the retreived page text.
  ieBrowser.Quit

End Function
-------------------------------------------------

There is much more that can be done with the internet object but this should put you on the right track.

Hope this helped.

Thanks very much for the prompt reply; it is just what I needed to get started!

Astrid Van Maanen