After sending a form to use on my new computer I keep getting error/debug messages. I changed all the needed information in the code as to where the new form is to be saved etc. however this one line keeps coming up as being something wrong. The code works just fine in my 2010 Excel version but not at all in the 2016 update. Anyone know what I'm missing?
This is the highlighted area each time I try to save it:
Full Module code reads as follows:![]()
[ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook]
Any help would be appreciated.![]()
[Sub SaveInvoiceWithNewName() Dim NewFN As Variant ' copy invoice to a new workbook ActiveSheet.Copy NewFN = "C:\Users\Candice\Documents\WRI\Billings\" & Range("J12").Value & ".xlsx" ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook ActiveWorkbook.Close NextInvoice ActiveSheet.Shapes("Textbox 8").TextFrame.Characters.Text = "" End Sub]
Thanks,
D
Bookmarks