Here is a sample VBA code that you can use to auto convert excel files to PDF using Nuance PDF Converter Professional 8:
Sub ConvertToPDF()
Dim PDFConv As Variant
Dim ExcelFile As String
Dim PDFFile As String
ExcelFile = ActiveWorkbook.FullName
PDFConv = CreateObject("NuancePDFConverterProfessional8.NuanceConverterProfessional")
'Set the path of the output PDF file
PDFFile = Replace(ExcelFile, ".xlsx", ".pdf")
'Convert the file to PDF
PDFConv.OpenInputFile ExcelFile
PDFConv.SetConvertToPDFFileName PDFFile
PDFConv.ConvertToPDF
PDFConv.CloseInputFile
Set PDFConv = Nothing
End Sub
To add the Nuance PDF Converter Professional add-in, please follow these steps:
- Open Excel 2019.
- Click on the "File" tab and select "Options".
- In the "Excel Options" window, select "Add-Ins" in the left menu.
- At the bottom of the window, select "Excel Add-ins" from the "Manage" dropdown menu and click "Go".
- In the "Add-Ins" window, click on the "Browse" button and navigate to the folder where Nuance PDF Converter is installed.
- Select the "NuancePDFConverterProfessional8.xlam" file and click "Open".
- The add-in should now appear in the list of available add-ins. Check the box next to it and click "OK".