Export to .pdf with default name

[jgelpi16]

I would like to export a report to PDF format. However, I don't want to use the report name as the default file name. Is it possible to do that?



Report Name: Report1
Desired .pdf name: PDFFile

Here is the code I am using, but when you do save it the file name defaults to Report1

    DoCmd.OutputTo acOutputReport, "Report1", "PDF Format (*.pdf)", "", False, "", 0, acExportQualityPrint

Thank you!

[pbaldy]

You can specify the name in the output file argument. Here's an example:

DoCmd.OutputTo acOutputReport, "rptBooking", acFormatPDF, GetBEFolder("tblbookings") & strFileName & ".pdf"

That uses a function to find the path and a variable for the name (strFileNam).

[jgelpi16]

Perfect. Thank you!

[pbaldy]

No problemo!