Hi, I have a filecopy script, but if the file is open, then it won't save. I would like to write a script that says if the file is open, then save it to name with suffix _V2. The file is created several times during the day I will always overwrite unless the file is open. any help is highly appreciated. (ich kann auch deutsch lesen)
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"