Consulting

Results 1 to 2 of 2

Thread: HTTTP Post Request Help Needed

  1. #1

    HTTTP Post Request Help Needed

    I have an HTTP line of code that goes to a specified URL and responses back with the requested information. Some of the URLs can only be accessed after logging onto a member site so I need to be able to log into a website with my username and password and then run the HTTP GET. I am not really sure how to incorporate the Http POST into this process. The oriURL is listed in an Excel cell. Any help or suggestions is greatly appreciated.
    If ws.Cells(i, 2) <> "" Then

    oriURL = Trim(ws.Cells(i, 2).Value)
    Application.StatusBar = "Processing Row#" & I
    j = 1
    resultFound = True
    targetSheetCreated = False
    Do While resultFound 'And j < 3
    resultFound = False
    If j <> 1 Then

    If (Right(oriURL, 1) = "/") Then
    URL = oriURL & CStr(j)
    Else
    URL = oriURL & "&page=" & CStr(j)
    'URL = oriURL & "/" & CStr(j)
    End If
    Else
    URL = oriURL
    End If

    On Error GoTo InvalidUrl

    'Call the URL and Get Requested Info
    Http.Open "GET", URL, False
    'MsgBox URL
    Http.Send

  2. #2
    you would need to add any hidden input values (from the page loaded after login) to your request, unless the login information can be sent in the request, these will indicate a valid login, and other information, as to what to "get"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •