​ This Tech Tip was provided by, Research Analyst, Tufts University. Our office produces many department-level and individual-level reports. These reports are often created in an Excel workbook containing worksheets named after each department or individual.

For example, we create advising reports for all of our academic advisors in an Excel workbook that contains a worksheet for each individual advisor’s report. Because we give each advisor his/her own report as a PDF, we must save each workbook as a PDF file. The process can actually be completed quickly through the use of VBA code in Excel, as this Tech Tip explains. I have included a link to the VBA code along with some directions, but for more documentation on using this code, please visit the. Within your Excel workbook, create a worksheet titled “WorksheetNames.” In column A of the “WorksheetNames” worksheet, list all the names of the worksheets for which you plan to create a PDF.

It is important that the names of the worksheets be reproduced exactly. Open the Visual Basic Editor in Excel (Developer - Visual Basic). Because the Developer tab does not appear in Excel 2010 by default, it may need to be enabled.

To enable the Developer tab: •. Additional directions on using VBA in Excel can be accessed on the. Once the VBA Editor is open, you may need to change the view so that you are in “Code View.” To do this, go to View - Code. Paste the (and shown below as reference) into the Visual Basic Editor. The variable “numSheets” will need to be replaced with the number of worksheets that will be saved as a PDF file. Mutant Rampage Bodyslam Iso more. (In the example above, it would be 4).

I have a workbook I inherited that includes a print macro to print only the Selected worksheets. Export Worksheet to PDF using VBA. (Save As) PDF. I was hoping someone could help me with a problem I am facing. I currently have an Excel 2007 workbook containing 47 worksheets. I need to save each i. Learn how to use VBA code to save Excel worksheets, charts, and entire workbooks as PDF files.