I'm trying to get date into the folder name as shown below but i'm giving me an error. Does anybody know how to format this properly
"C:\Users\Tyler\ Capital\Administration - Documents\2. Finance\Expenses\1. General\Advisors Reimbursement Invoices\& Format(Now, "yyyy-mm")& \" & Format(Date, "(mm-yy)") & ".PDF" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
"C:\Users\Tyler\ Capital\Administration - Documents\2. Finance\Expenses\1. General\Advisors Reimbursement Invoices\& Format(Now, "yyyy-mm")& \" & Format(Date, "(mm-yy)") & ".PDF" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True