Saving file with specific YYYYMMDD_File Name at the end of the macro

[drozek]

Is there a way at the end of the macro, everything is working perfectly for me, to save the file in a specific folder on the hard drive with "YYYYMMDD_Forward Order.xlsm"?

The YYYYMMDD should be the date the macro is ran

Save and close it also?

Thanks!

 

[drozek]

I tried:

ActiveWorkbook.SaveAs (“C:\Users\RozekD\Documents\XXXXX\Non-Customer\Reports\Forward Order Reports\ “ & Format(Now(), “YYYYMMDD & _Forward Order”) & “.xlsm”)

But it didn't work

 

[shg]

Didn't work in what way? What happened?

The director must exist.

 

[drozek]

Didn't work in what way? What happened?

The director must exist.

Compile error:

Syntax error

 

[drozek]

Or I sometimes I saw

Compile Error

Expected: list separator or )

 

[shg]

VBA uses straight quotes:

  ActiveWorkbook.SaveAs "C:\Users\RozekD\Documents\XXXXX\Non-Customer\Reports\Forward Order Reports\" & _
                        Format(Now(), "YYYYMMDD") & "_Forward Order" & ".xlsm"

 

[drozek]

VBA uses straight quotes:

  ActiveWorkbook.SaveAs "C:\Users\RozekD\Documents\XXXXX\Non-Customer\Reports\Forward Order Reports\" & _
                        Format(Now(), "YYYYMMDD") & "_Forward Order" & ".xlsm"

Gah makes senses, thank you!