VBA Name File and add current Date

0

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

Answer
Discuss

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
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login