save & Clear

[baigsahib]

Sub SaveInvWithNewName()
Dim NewFN As Variant
' Copy Invoice to a new workbook
ActiveSheet.Copy
NewFN = "C:\Users\Donny\Google Drive\Data\Invoice" & Range("B15").Value & “.xlsx”
ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
NextInvoice
End Sub


NewFN is posting an error
Can you help?

 

[Joe4]

Welcome to the Board!

Don't know if this is your issue, but VBA is VERY particular about double-quotes. It does not like the slanted ones you have around xlsx.
So try changing this:
“.xlsx”
to this
".xlsx"

 

[baigsahib]

Beautiful
Awesome
it's working