winhttprequest

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...

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...

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...

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 =...

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...

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"...

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...