convert excel to pdf

(0) Share

Report

Posted on by geothermusa

Hello there,

can anyone suggest to me the flow that I use to convert excel to pdf?

so I have created an ms form and the form asks to attach an excel file then I am taking that excel file into my power to automate the flow and then want to convert it to a pdf file. does anyone have any suggestions?

Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

werkbook 36 on at

Like (1)

Report
Copy link

Link copied!
@geothermusa

The following is one possible solution:

You will need to make use of the action Run VBScript to execute the following code:
Dim Excel Dim ExcelDoc 'Opens the Excel file' Set Excel = CreateObject("Excel.Application") Set ExcelDoc = Excel.Workbooks.open("%ExcelFile%") 'Creates the pdf file' Excel.ActiveSheet.ExportAsFixedFormat 0, "%OutputPDFFile%" ,0, 1, 0,,,0 'Closes the Excel file' Excel.ActiveWorkbook.Close Excel.Application.Quit

Do remember to use the action Set variable to assign the full path of your Excel file to %ExcelFile%, and to assign the full path of the output PDF file to %OutputPDFFile%.

To learn more, please visit VBScript snippets (werkbook.co)

Was this reply helpful? Yes No
geothermusa 67 on at

Like (0)

Report
Copy link

Link copied!

Dear Werkbook,

I am using the power automated platform as explained in the description. That would be great if you help me with the actual flow.

Thank you

Was this reply helpful? Yes No