- Run out your report. I have run out a copy of my Financial Report Designer containing three financial layouts.
- To be able to work with macros, you'll need to enable the Developer tab. Do this by selecting File, Options, Customize Ribbon, check Developer under Main Tabs and click OK.
- Next, select the Developer Tab, click Record Macro, give your macro a name and click OK.
- Now go to File, Save As, and save your workbook to a preferred location as a PDF file.
- Before clicking Save, click Options and select Entire workbook under Publish what.
- You can now click OK and click Save.
- Stop your macro by clicking Stop Recording on the Developer tab.
If you would like to view the code for it, you can do so by clicking Visual Basic on the Developer tab, opening Modules, and then selecting Module 1.
- Next save your workbook to your preferred location as a Macro Enabled file.
- Now go back to your Report Manager and save the workbook back to your report using Save Excel Template.
- When asked to specify a template name, make sure you change the file format to .xltm.
- Lastly, select your report and under the Run Macros field under the properties, enter the name you gave your macro and click Apply.
You can now run out your report and each time you do so, all visible sheets will be saved to a single PDF document in the location you specified. Take note that depending on the extent of your layouts, you may want to adjust your workbook page settings before saving your workbook to your report to have them display optimally in your PDF.