I just need to change some in my existing code. this code download zip files from one site from start date to end date mention on excel cells. but it only for current year only if I have to download for past years ...it cant I have to change year in code
With oFso If Not .FolderExists(strSavePath) Then MakeMultiStepDirectory strSavePath End If End With iYear = 2014 datLastDate = DateValue(strEndDate) 'DateSerial(iYear, 4, 9) datWorkDate = DateValue(strStartDate) 'DateSerial(iYear, 1, 1)
I tried but not working and I want loop to all dates between start date and end date.
Sir.Gowflow,
Attached WB working but it ask for year in message box ...need to download all files between start date (cell A1) to end date (cell B1) in one click (Button Download) .....current it ask for year. needed - say start date is 1 jan 2013 & end date 20 apr 2014 then it will download all files between this dates irrespective of year i.e. no message box.
Open in new window
Open in new window