Filecopy, if file is open new name
01.11.2016 12:27:51
Steven
Here the command:
FileCopy "I:\ELC\SAP Data\Templates\PL_Analysis_20161005 - Kopie.xlsx", "I:\ELC\SAP Data\PL_Analysis_" & Format(Date, "yyyy_mm_dd") & ".xlsx"