Macro to download folders based on the data range

[swisshome]

Hi, so I have this problem: I want to be able to download url folders based on the start date (dtReportDateStart) and end date (dtReportDateEnd). So I want start date, what's in between and end date.

My code:

Sub Get_XY()
    Dim dtReportDateStart As String
    Dim dtReportDateEnd As String
    Dim strPricesLocation As String
    Dim strPricesDestination As String
   
    dtReportDateStart = Format(ThisWorkbook.Worksheets("Dashboard").Range("C2"), "YYYYMMDD")
    dtReportDateEnd = Format(ThisWorkbook.Worksheets("Dashboard").Range("C3"), "YYYYMMDD")
   
    strPricesLocation = "http:/..." & dtReportDateStart & ".tsv.txt"

End Sub

 

[swisshome]

In was thinking about some loop which would assign the FName to be the Start, between or End

If dtReportDateStart < dtReportDateEnd Then
        FName = Mid( ? , FName + 1)
    Else
        FName = "?"
    End If