mato01
asked on
Save file with date and new name
Need help on why I'm getting a compile error that state "
The result of the file name should be like
10/26/11 DWW NNNNN ABC#11111
Any thoughts?
Sub SaveWeeklyConstraintFile()
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Users\abcde\ Documents\ Constraint File Upload\MM-DD-YY Weekly Dealer Constraints.xlsx"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\abcde\Documents\ Constraint File Upload\Format(Now(), "mmm-dd-yyyy")" & "DWW NNNNN ABC#11111", FileFormat:=xlOpenXMLWorkb ook, CreateBackup:=False
ActiveWorkbook.Close False
'Call Workbook_Close
End Sub
The result of the file name should be like
10/26/11 DWW NNNNN ABC#11111
Any thoughts?
Sub SaveWeeklyConstraintFile()
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Users\abcde\
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\abcde\Documents\
ActiveWorkbook.Close False
'Call Workbook_Close
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.