How do I export an MS Access Report to a pdf format via VBA to a slected path
Posted on 2014-09-15
I have a few reports I want to export to pdf, but only after being prompted to select the path. How would I in the below example be prompted each time I export a report to select the path/file for MyPath & Myfilename
DoCmd.OutputTo acOutputReport, "VolunteerRoster", acFormatPDF, Mypath & Myfilename, False, , , acExportQualityPrint...
Would I need to use the DIR command or some form of the Windows scripting file ?