Results 1 to 3 of 3

Thread: extract data from web

  1. #1
    Acolyte aswathy0001's Avatar
    Join Date
    Nov 2016
    Location
    india
    Posts
    24
    Articles
    0
    Excel Version
    2010

    Post extract data from web



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i want to extract data from https://www.visionwheel.com/dealers/dealer-search.cfm for each zip code
    i tried with zipcode 75211 but i doesnt get the full url
    tried with https://www.visionwheel.com/dealers/dealer-search.cfm?zipCode=75211 but can
    any one help?

  2. #2
    Acolyte aswathy0001's Avatar
    Join Date
    Nov 2016
    Location
    india
    Posts
    24
    Articles
    0
    Excel Version
    2010
    any help?

  3. #3
    Neophyte ArdusPetus's Avatar
    Join Date
    Mar 2020
    Posts
    1
    Articles
    0
    Excel Version
    2019
    The form is a POST form, not a GET one.
    Your request should be like this:
    Code:
        
    With oXMLH        
        .Open "POST", "https://www.visionwheel.com/dealers/dealer-search.cfm"
        .send "Zipcode: " & zip
    HTH,
    --
    AP

Posting Permissions

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