Hi Could anyone help me please? im trying to make my excel workbook faster to use so i want to be able ideally to click one/ two buttons to save only one sheet as a pdf & type out the email body "Hello,
Please find the quote attached" & subject"Quote" & upload the pdf.But i want to enter the email address myself.
Additionally id like to save just the active worksheet again as a excel workbook. With the file name coming from m1.
My biggest problem is I dont know how to only get the macro to make the pdf & single worksheet to save as page 1 cells A1:I4 on the "quote" sheet as theres other stuff I dont want to be on these. What I have so far is:
So as you can see I want the PDF to be saved in: C:\Users\John\Desktop\Blank Cost Sheets\AUTO QUOTE PDFPlease Login or Register to view this content.
Also id like the worksheet to be saved in: C:\Users\John\Desktop\Blank Cost Sheets\AUTO QUOTE
I really dont know what im doing. I just found this code online and have spend a while trying to make it work for me. Thanks
Also I think I’ve posted the code correctly but it’s not easy on my phone
Bookmarks