trying to get data from web page

  • Thread starter Thread starter Gary Walter
  • Start date Start date
G

Gary Walter

the following URL will open a page giving
file info for msjet.dll version 4.0.2521.8

http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=129382

I would like to get this info into Access.

**Without really knowing what I am doing***
I tried an ADO Record and an ADO Stream:

Function getdllinfo()
Dim s As ADODB.Stream

Set s = New Stream

s.Open
"URL=http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=129382",
adModeRead, adOpenStreamUnspecified
Debug.Print s.ReadText(adReadAll)

s.Close
Set s = Nothing

'Dim grec As ADODB.Record
'Dim grs As ADODB.Recordset

'Set grec = New Record

'grec.Open "",
"URL=http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=129382",
adModeRead, adOpenIfExists
'Set grs = grec.GetChildren
'While Not grs.EOF
' Debug.Print grs(0)
' grs.MoveNext
'Wend

'grs.Close
'Set grec = Nothing
'Set grs = Nothing


End Function

Both choked on the Open stmts.

I assume because it was not a "simple file"
but involved "moreinfo.asp"

I admit I don't know what I am doing!

Does anyone have some strategy for doing
something like this? Or can someone tell me
explicitly that I am on a fool's errand?

Thank you,

Gary Walter
 
never mind...

I guess I will just use Dev's inettransfer
to save to text file and parse it out.
 
Back
Top