Sheets → PDF

Location on ribbon: Tab DVD Addin → Group File and Print

Command ID: btnSelectedSheetsToPDF

What it does

The command exports the currently selected sheets to PDF in one click, writing one PDF per sheet into the folder that holds the workbook. Each file is named <workbook name>_<sheet name>.pdf, so the results group together and it is obvious which submittal they belong to.

It is handy whenever different parties need different forms: the quantity sheet for the consultant, the inspection record for the client, the programme for a subcontractor — with no Save As dialog and no typing a file name for each sheet.

How to use

1. Save the workbook first, because the PDFs are written into the workbook's own folder.
2. Select the sheets to export: click the first tab, then hold Ctrl for individual tabs or Shift for a contiguous run.
3. Go to tab DVD Addin → group File and Print → click Sheets → PDF.
4. The add-in activates and exports each sheet in turn, with screen updating suspended so the run is faster.
5. When it finishes, a message reports how many sheets were exported, how many failed, and the folder the files went to.

Example

The workbook Payment_App_3.xlsx sits in the project folder and contains the sheets Quantities, AnnexA, AnnexB plus a few internal calculation sheets.

Hold Ctrl, select the three sheets you need to issue, and click Sheets → PDF. The project folder now contains Payment_App_3_Quantities.pdf, Payment_App_3_AnnexA.pdf and Payment_App_3_AnnexB.pdf, while the internal sheets stay private. Attach the three files to your email and you are done.

Notes

• The output is several PDFs, one per sheet, not a single combined document; to get one booklet use batch print with its combine option, or merge them with the PDF manager.
• At least one sheet must be selected and a workbook must be open; otherwise the add-in reports the problem and stops.
• For workbooks synced through OneDrive/SharePoint, the add-in resolves the online path to the local folder before exporting, avoiding the "invalid directory name" export error.
• Hold ESC to stop mid-run; sheets already exported are kept and the message tells you how far it got.
• Sheet names containing characters Windows does not allow in file names are sanitised automatically.
• An existing PDF of the same name in the folder is overwritten without asking.

Related

• Batch print — loop-driven PDF export that can merge everything into one file.
• Set page margins — align paper size and margins across sheets before exporting.
• Print pages — when you only need a few pages, not whole sheets.
• Word to PDF — convert Word documents to PDF in bulk.