Access to HTML

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rizza - 28 Feb 2005 15:29 GMT

I am looking for an example of how to pass a value from access to a web page
input box. I would like to use VBA rather than third party software if
possible.

Reply to this Message

Rick Brandt - 28 Feb 2005 16:16 GMT

> I am looking for an example of how to pass a value from access to a
> web page input box. I would like to use VBA rather than third party
> software if possible.

You can submit HTTP requests using the MSXML library.

Dim MyPostData As String
Dim MyURL As String
Dim oHttpPost As Object

MyPostData = "SomePageVariable=SomeDataValue"
MyURL = "http//www.SomeDomain.Com/SomePage"
Set oHttpPost = CreateObject("Microsoft.XMLHTTP")
oHttpPost.Open "POST", MyURL, False
oHttpPost.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
oHttpPost.Send (MyPostData)

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message