I have one WB which download files from site. for this I have to give time range in Cell C2 (Start Date) & in C3 (End Date "TODAY()"). I need 2 things in existing code .
A Code automatically capture last file download date in Cell C2.
B before downloading it clears all file from downloading location.