Excel as PDF

RajathGopal1 — Tue, 27 Aug 2019 09:09:00 GMT

Hello,
I am trying use save as on an excel to save the excel as PDF.
Manually when i do a save as and select filename and filetype as .pdf a macro runs to generate a report.
However in blue prism "save workbook as" action only saves the specific excel as pdf but does not change the file type which does not yield right resolution.
However i tried extending the functionalities using ExportAsFixedFormat function this did not work as this just exports as pdf but does not run the macro.

So is there any other functionality that we can use to achieve this other than attaching the window and sending keystrokes manually to get the saveas wizard window ?

Many Thanks in Advance

------------------------------
Rajath Gopal
------------------------------

RE: Excel as PDF

John__Carter — Wed, 28 Aug 2019 15:28:00 GMT

"a macro runs to generate a report" - does this mean your Excel has some sort of bespoke VBA invoked on Save As? Can you find out what this macro is and maybe try to call it directly?

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

topic RE: Excel as PDF in Product Forum

Excel as PDF

RE: Excel as PDF