trying to get data from web page

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
 
G

Gary Walter

never mind...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top