@JasGot said in Late Night VBA Help Needed:

@garak0410
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

Also this is what I've done, but modified the latter half of the page to keep everything in place.

Hi @JaredBusch you absolutely understand what i'm trying to do but I already done with this project.

but anyway thank you for your reply i really appreciate it. maybe a few weeks later i will ask again for your help. hahaha