cancel
Showing results for 
Search instead for 
Did you mean: 

Excel as PDF

RajathGopal1
Level 2
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
------------------------------
1 REPLY 1

John__Carter
Staff
Staff
"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
------------------------------