Hi,
I have a string which reads the date as 20240730
"C\backup\LReports" & "\Output\" & sFolderLocation & "\" & "Report_" & sDateTimeStamp & ".xlsm"
sFolderLocation = CStr(Year(Now())) &
Pad(CStr(Month(Now())), 2)
sDateTimeStamp = CStr(Year(Now())) & _
Pad(CStr(Month(Now())), 2) & _
Pad(CStr(Day(Now())), 2)
If I need to read the 07/29(the day before) or on Mondays, if I need Friday's date (20240726) file, how to use that in my variable?
I have a string which reads the date as 20240730
"C\backup\LReports" & "\Output\" & sFolderLocation & "\" & "Report_" & sDateTimeStamp & ".xlsm"
sFolderLocation = CStr(Year(Now())) &
Pad(CStr(Month(Now())), 2)
sDateTimeStamp = CStr(Year(Now())) & _
Pad(CStr(Month(Now())), 2) & _
Pad(CStr(Day(Now())), 2)
If I need to read the 07/29(the day before) or on Mondays, if I need Friday's date (20240726) file, how to use that in my variable?