Hi, all. I have this one program where it can transfer the data from Excel to PowerPoint. I have to add another feature in my code that runs from Excel, which is to convert or print the active PPT file to PDF. The issue is I can't seem to find the solution for this. I only have a code that do the conversion but runs from PPT only, not Excel.
Code that runs from PPT to convert PPT slides to PDF:
Public Sub ExportAsFixedFormat_Example()
ActivePresentation.ExportAsFixedFormat "C:\Users\my097a\Desktop\test.pdf", ppFixedFormatTypePDF, ppFixedFormatIntentScreen, msoCTrue, ppPrintHandoutHorizontalFirst, ppPrintOutputSlides, msoFalse, , , , False, False, False, False, False
End Sub
Hereby I attached my Excel file for you to refer to along with the PPT template. PowerPoint from Excel.xlsbTemplate.pptx
May I also know how to add a feature in which user is prompted to select the folder of the pdf file to be saved and the user may name the pdf file as well?
Hope anyone can enlighten me. Thanks!