Change PDF File Name

[Billy Spivy]

Hello all,

I have a macro run by the ''Save Checkstubs to PDF File' on the 'Paystubs'! sheet.
Please is there a way to change the names of the PDF output files to:

Employee Name - 2/25/2018 - 3/3/2018



There will be other pay periods so I don't want to replace the files from previous weeks. The Employee Name is in D4 and the pay period is in D7 & E7. I'm not sure if having the dashes is the best way so I appreciate any suggestions.

Thank you very much for your help,
Billy

[mike7952]

Give this a try

Please Login or Register  to view this content.

[Billy Spivy]

Thank you Mike I will give it a try when I get back to the office. I noticed you have a file path added for your desktop. I'm curious can there be multiple file locations? The reason I ask is sometimes I work on different PCs but I will save a backup to my Google Drive.