I have a Macro enable template with the below Macro that you wrote. It works but I would like for it to save the new file as a macro enable file "xlsm" instead of an excel .xlsx file. Is this possible?
Sub SaveAndNewInvoiceWithNewName()
Dim NewFN As Variant
' Copy Invoice to a New Workbook
ActiveSheet.Copy
NewFN = "C:\Users\Eddie\Documents\IDrive-Sync\Dropbox\LB Historical Society\Treasurer's Programs\Invoicing\Invoices\" & Range("F10") & Range("G10") & Range("H10") & Range("C22") & Range(" D17 ").Value
ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
NextInvoice
Range("G10").Value = Range("G10").Value + 1
Range("C25:D42").ClearContents
End Sub
Sub SaveAndNewInvoiceWithNewName()
Dim NewFN As Variant
' Copy Invoice to a New Workbook
ActiveSheet.Copy
NewFN = "C:\Users\Eddie\Documents\IDrive-Sync\Dropbox\LB Historical Society\Treasurer's Programs\Invoicing\Invoices\" & Range("F10") & Range("G10") & Range("H10") & Range("C22") & Range(" D17 ").Value
ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
NextInvoice
Range("G10").Value = Range("G10").Value + 1
Range("C25:D42").ClearContents
End Sub