I am trying to use VBA code to name and save the file with current date
End Result and format I need:
"PHS Worksheet Warning Report GAFG Non End 12-27-2018"
Save to location:
C:\Users\bsronce\Desktop\PHS Warning
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
VBA Name File and add current Date
0
Answers
0
Selected Answer
try
Sub filesave()
ActiveWorkbook.SaveAs ("C:\Users\bsronce\Desktop\PHS Warning\PHS Worksheet Warning Report GAFG Non End " & Format(Now(), "MM-DD-YYYY") & ".xlsx")
End Sub