Export MS Excel to PDF-file including Header/Footer

JariKorkkinen — Tue, 15 Aug 2017 11:52:00 GMT

Hello, I created an action to export Excel sheet to PDF with the help of this instruction in Knowledge Base: https://portal.blueprism.com/customer-support/knowledge-base/how-do-i-export-pdf-file-using-ms-excel-vbo This works like a charm but I would need to print header and footer as well and those are not printed unless the view is changed (Show > Page setup) . I´d prefer not to do it like that so the question is: Is there a way to alter the code to print also header + footer? Here´s the original code: Dim wb as Object = GetWorkbook(handle,workbookname) Dim excel as Object = wb.Application excel.DisplayAlerts = False wb.ActiveSheet.ExportAsFixedFormat (Type:=0, Filename:= "C:\Temp\MyTestPDF.pdf", Quality:=0, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False) excel.DisplayAlerts = True Best Regards, Jari

RE: Export MS Excel to PDF-file including Header/Footer

JonathanHolstin — Fri, 10 Apr 2020 03:09:00 GMT

Hi Jari,
I know this thread is very old but I was hoping to find the Excel to PDF instruction for Blue Prism. The link you provided is no longer valid.

Thanks,
Jon

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

topic Export MS Excel to PDF-file including Header/Footer in Product Forum

Export MS Excel to PDF-file including Header/Footer

RE: Export MS Excel to PDF-file including Header/Footer