Forum Discussion
Macros and VBA
How can I substitute "-" for "/" in the dates so I can use the dates in the file name? NewFile = "Financial Report " & Sdate & " to " & EDate & "_" & Unique & ".xlsx" Sdate and Edate are from a col...
NewFile = "Financial Report " & Format(Sdate, "yyyy_mm_dd") & " to " & Format(EDate, "yyyy_mm_dd") & "_" & Unique & ".xlsx"