Web data into Access form

I am trying to use Access/VBA to get some information from a webpage and enter it into a textbox.

I suppose you could draw comparisons to the Get External Data (Web Query) functionality in Excel but instead using Access.

Can you do this using ADO or DDE?

Are there any examples that I can reference?

Any assistance would be kindly appreciated

Re: Web data into Access form

I couldn't quite figure out how to 'complete' the thread after I have been doing some more web searching and came across this fantastic article by By Rick Strahl at West Wind

http://www.west-wind.com/presentations/shellapi/shellapi.asp

Although it was for Visual FoxPro I managed to adapt it to my needs in VBA/Access.

See function below which brings back the body html and filters only for information between the start and end string

Function TextFromHTML(URL As String, StartString, EndString) As String
  Dim IE As Object
  Dim strtext As String
  Dim StartPos As Long
  Dim EndPos As Long
  
  Set IE = CreateObject("InternetExplorer.Application")
  IE.Navigate URL
  Do Until IE.ReadyState = 4
  On Error Resume Next
  strtext = IE.Document.Body.OuterHtml
  StartPos = InStr(1, strtext, StartString)
  EndPos = InStr(1, strtext, EndString)
  TextFromHTML = Mid(strtext, StartPos, EndPos - StartPos)
  On Error GoTo 0
  Loop
  IE.Quit
End Function