Print to PDF

[SierraJuliet]

What is the VBA extension to publish a form to PDF instead of printing. The specific item I am looking to activate is "External Data > PDF or XPS"



I am looking for something similar to:
"Linked Table Manager" VBA code - DoCmd.RunCommand acCmdLinkedTableManager
"ODBC Database" VBA code - DoCmd.RunCommand acCmdImportAttachODBC

[SierraJuliet]

This is the VBA code for "External Data > PDF or XPS" feature

DoCmd.RunCommand acCmdExportFixedFormat

[June7]

Shouldn't need to activate a library. You can use: DoCmd.OutputTo

If you want to open the Print dialog and select something like 'Microsoft Print to PDF' driver: DoCmd.RunCommand acCmdPrint

Otherwise, executing ribbon button might be possible with CommandBars.ExecuteMSO. The only one I know about is:

CommandBars.ExecuteMSO "DataRefreshAll"

I can't figure out the reference for External Data PDF/XPS button.

And I see now you found a RunCommand reference. Great!

[SierraJuliet]

If I did DoCmd.OutputTo then I would need to specify a directory and would prefer the user to choose for flexibility. The aforementioned code I submitted as the solution performs all the same functions and includes flexibility with directory selection with minimum coding required.

DoCmd.RunCommand acCmdExportFixedFormat

This is a list of acCmd enumerations for those who are interested in streamlining their code - https://docs.microsoft.com/en-us/off...cess.accommand

[June7]

Could use fsoFileDialog to allow user to select destination but I suppose you already know about it.