Ease of Use

Easy

Version tested with

2016 

Submitted by:

mdmackillop

Description:

The userform utility allows for publishing the workbook to the existing file location or to other specified location (Desktop/PDF Files in the sample). Previous PDF file names are listed in the userform to simplify reuse (overwriting) or adaption (revision) of file names. 

Discussion:

Reports in PDF format are commonly saved in the workbook location or some other location where easily located for importation to emails or other purpose. Reusing or revising file names allows for consistency in the process. The sample allows addition of a date suffix; easily adapted to other use. 

How to use:

1. Export the userform and reimport it into your Personal template.
2. Copy the button code into a module in your Personal template.
3. Create a shortcut or add a ribbon or QAT button to open the userform.

Test the code:

1. Save the attached workbook
2. Click the Open Userform button
3. Publish the sheet to the workbook location
4. Use the button to create a PDF Files folder on the desktop
5. Publish the sheet to the PDF Files location
6. Change/adapt the name.
7. Note: A new file will not be created if a previous PDF of the same name/location is open.

Sample File:

frmPDFx.zip 28.04KB 

Approved by Jacob Hilderbrand