1. J

    CSV from Website CreateObject("Microsoft.XMLHTTP")

    Hello, I have the below bit of code that will connect to a website download the .csv file into a location. At the moment I have set this on a loop of about ten files and save them in a location. I then copy all the data from the ten files download into one master worksheet. What I would like...
  2. 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...

Some videos you may like

This Week's Hot Topics