confused in Frankfurt
Board Regular
- Joined
- Oct 11, 2010
- Messages
- 53
Hi there,
I have a macro to create a worksheet and it is not saving the file returning the error 424.
In my code I define the folder and the file name.
Dim Folder As String
Folder = "A:\Controlling\2014\Reporting\CARS\Template\CARS\06_Jun\"
Dim RSM As String
Selection.Offset(0, 2).Select 'cell in file where RSM name
RSM = Selection
Dim timestamp As String
timestamp = Format(Date, "yyyymmdd")
Dim NBName As String
NBName = "CARS_" & RSM & timestamp & ".xlsm"
ActiveWorkbooks.SaveAs Filename:=Folder & NBName _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
when I scroll over the defined names in the last code it shows the following:
-- removed inline image ---
-- removed inline image ---
I am not sure why the file is not saving and which object is missing.
Regards
Sarah
I have a macro to create a worksheet and it is not saving the file returning the error 424.
In my code I define the folder and the file name.
Dim Folder As String
Folder = "A:\Controlling\2014\Reporting\CARS\Template\CARS\06_Jun\"
Dim RSM As String
Selection.Offset(0, 2).Select 'cell in file where RSM name
RSM = Selection
Dim timestamp As String
timestamp = Format(Date, "yyyymmdd")
Dim NBName As String
NBName = "CARS_" & RSM & timestamp & ".xlsm"
ActiveWorkbooks.SaveAs Filename:=Folder & NBName _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
when I scroll over the defined names in the last code it shows the following:
-- removed inline image ---
-- removed inline image ---
I am not sure why the file is not saving and which object is missing.
Regards
Sarah