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
