Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VBA
It seems like this should be easy, but I cannot find the syntax to open the target web page with WinHTTP.WinHttpRequest.5.1 in VBA (MS Access). Maybe this isn't the right forum for the question, but since the class is used in VB too, hopefully someone has the answer.
 
Basically I'm POSTing some parameters to an aspx page, which I would like to display after processing the Posted parameters.
 
Is this even possible?
 
Here is a subset of the code. the aPostBody string contains the parameters. The code behind thepage.aspx.vb gets the parameters and returns a response.
 
Dim WinHttpReq As Object 'WinHttp.WinHttpRequest
Dim stURL as string
dim aPostBody as string
dim aResponse as string
 
Set WinHttpReq = CreateObject("WinHTTP.WinHTTPRequest.5.1") 'New WinHttpRequest
stURL = "http://somewebsite.com/thepage.aspx"
WinHttpReq.setRequestHeader "Content-Type", "multipart/form-data; boundary=" & boundWinHttpReq.Open "POST", stURL, False
...
WinHttpReq.Send aPostBody
aResponse = WinHttpReq.GetResponseHeader("theResponse")
 
However, instead of getting the response header, I would like to open the page using the parameters I just sent. Ie, if I'm passing a record number, I want the page to display a database record with that record number.
 
I realize I can pass a query string to open the page to a particular record, but I don't want it accessible that way.
Posted 15-Feb-12 17:22pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 CPallini 345
1 BillWoodruff 324
2 George Jonsson 279
3 Sergey Alexandrovich Kryukov 258
4 OriginalGriff 227
0 OriginalGriff 5,050
1 CPallini 4,225
2 Sergey Alexandrovich Kryukov 3,639
3 George Jonsson 2,911
4 Gihan Liyanage 2,386


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 15 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100