@JasGot said in Late Night VBA Help Needed:
Is the original document already an excel spreadsheet? and in this function that e-mails the document you also want to "save As" the document?
This is what we use in one of our vba apps, it saves the excel to a new name in another folder.SaveAsFileName = "s:\Sales Docs\Quotes\Sales\" & Forms!Call_Ticket!Combo101 & "-" & Forms!Call_Ticket![Project Name] & ".xls" xlApp.ActiveWorkbook.SaveAs (SaveAsFileName) Set xlSheet = Nothing Set xlBook = Nothing Set xlApp = Nothing