winhttprequest

  1. S

    WinHttpRequest with POST times out

    Hello all, I'm trying to import some data for a fund listed on the Luxembourg SE. When I go to the site, I can insert the ISIN code, LU1883863935, in the search field and from there I can read the exchange symbol, 294814. As I'm trying to get the data into Excel, I can see when I use Inspect...
    • S_White
    • Thread
    • .setrequestheader post web scraping winhttprequest
    • Replies: 3
    • Forum: Excel Questions
  2. J

    VBA Code to Download Password Protected Excel File - Server Blocking Request

    I am trying to use the below code to download a list of daily reports from password protected sites. The server seems to be blocking the request. I have no issues when manually logging in to download each report. I am using Excel 2013 and not positive that this is the correct WinHTTP...
  3. S

    help Convert code from XMLhttp to WINhttp

    I have made a scraper using vba xmhttp method which is parsing yell.com very smoothly at this moment.However, I noticed that the site sometimes uses a redirection method.As a result I end up with nothing returned when I run the code.So if there is somebody out here that can help me create this...
  4. A

    WinHttpRequest as a function (us census API)

    Hi All, I have made a Sub that I would like to turn into a function, but am having issues getting it to work. here is the Sub I got to work and the function I am trying to get to work Public Sub Runapi() Dim W As Worksheet: Set W = ActiveSheet Dim URL As String: URL =...
  5. T

    Fetch CSV that is downloaded via an url

    Hey all, How do I get the underlying downloadable file downloaded, instead of the response html, when using winhttpreq? I have a URL (seen in the code below) that I can download a CSV file from. However, the url itself returns html when opened in code. When simply opening the link manually, I...
  6. X

    VBA - automate download of dynamicly generated csv from website

    Hello, Task: Using vba, automate the download of csv files from the following website: Current and Historical Alberta Weather Station Data Viewer In order to manually download a csv, once at this URL, select a weather station from the drop down on the right, let's say "Calgary Int'l Cr10"...
  7. J

    Do I Use WinHttp.WinHttpRequest or Microsoft.XMLHTTP?

    Sub Download() Set occXMLHTTP = CreateObject("Microsoft.XMLHTTP") Set fso = CreateObject("Scripting.FileSystemObject") DIY_Dir = "c:\DIYTraders\" DIYSub_Dir = "c:\DIYTraders\tickers\" If Not fso.FolderExists(DIY_Dir) Then MkDir DIY_Dir End If If Not fso.FolderExists(DIYSub_Dir) Then...
    • jjbungles
    • Thread
    • download yahoo finance microsoft.xmlhttp vba winhttprequest
    • Replies: 1
    • Forum: Excel Questions

Watch MrExcel Video

Learn Excel - "Hide Blank Rows Without a Macro" - Podcast #1736

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top