Help with save as PDF with Dynamic File Name: ActiveSheet.ExportAsFixedFormat method

Hi all,

I am working on an application to help us track our chemical applications. In the attached .xlsm file, the user would fill out the fields highlighted in blue on the "Field Application Sheet" tab. Then the "Save Form" button will have the primary function of saving the range B8:L42 as a PDF file with a dynamic file name. There are also header and footer fields that will need to be published with the PDF but I understand that if I set the IncludeDocProperties = True then they should be. In the attached example the file name I would want is:

"ChemApp_JQ Applicator_123456_St. John's Hwy ROW_3/20/2018_12:00:00 PM.pdf"

I am using the following code:

Please Login or Register  to view this content.

I've tried to research the issue but it's a bit over my head. I've been researching this problem for two days and have not been able to translate what I've found into a solution.
This is the first time I've tried using the ExportAsFixedFormat method. I appreciate the help. Thanks.

--TFiske

Your date-time format uses a backslash and a colon (3/20/2018_12:00:00 PM) which are a forbidden filename characters.

This converts the date-time format to use a dash; 3-20-2018_12-00-00 PM

Please Login or Register  to view this content.