Access to HTML

  • Thread starter Thread starter Rizza
  • Start date Start date
R

Rizza

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.
 
Rizza said:
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.
Click to expand...

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)
 
Back
Top