convert to pdf

Hi, Below is the code I'm using to create pdf files for each worksheet in an excel file. I'm looking to have the pdf files named after a cell value I2 in each tab however it is still working off the worksheet tab name. Sub pdfmultiplesheets() Dim saveInFolder As String Dim ws As Worksheet...

Hello, I have an Excel Workbook with 24 sheets. I want to create a single pdf document from this workbook. I know that each single excel sheet in the workbook will return 30 A4 pages when printed in pdf. I want to save the document with the name Numbers.pdf in a folder called Numbers ideally...

Dear all I need help. I have a pivot table which generates customer statements. I have 125 customers. what I do every month is I manually select each customer in report and save file as pdf and name it whatever name is in report filter (obviously the customer i selected) Now I know this can be...

In excel, you can track changes if you "share" a workbook. These changes appear like a comment in excel. I'm trying to export these comments via Adobe Acrobat, in a PDF. Instead I receive an error message, "Acrobat PDFMaker may not be able to convert comments and some links for shared...

I have a workbook that consists of 3 worksheets. Right now the way I have the code set in the workbook people push a button and an email is created that dumps in the entire workbook. Well now this workbook needs to go out to multiple people at the same time so I've put those emails into the BCC...

Below is a script I am using which runs solidly up to the point where I need the final output format to be .pdf instead of .xlsx I have the necessary addon for Excel and have tried to set the point FileExtStr = ".xlsx": FileFormatNum = 51 to FileExtStr = ".pdf": FileFormatNum = 17...