|
Good Morning,
is it possible to save a newly created workbook in the same path as the master workbook, plus in an additional folder?
So this is working fine:
ActiveWorkbook.SaveAs Filename:= _
"Z:\CRG\High Value\Security\Pre-Alert AT\PPS AT " & Format(Now(), "YYYY-MM-DD") & ".xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
In our network however, not every computer uses "Z:" and therefore the macro does not work, so I would like to save the new workbook under the "Pre-Alert AT" folder. The master workbook is saved under "Z:\CRG\High Value\Security". The folder is already in place.
Something like this:
ActiveWorkbook.SaveAs ActiveWorkbook.Path "Pre-Alert AT\PPS AT" & Format(Now(), "YYYY-MM-DD") & ".xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Many thanks in advance. |