Dear all,
Please find attached a sample excel file containing a long data table (worksheet 2). The worksheet has a defined header. The first 7 rows should be printed out on every page needed to show the table content. There is also a footer that provides additional information (page number, department, date…). If I save the workbook as pdf, there are two issues.
- The content of the table interleaves the footer area for all pages > 1
- The bookmark “detail” is linked to the last generated page instead to the first page, but in the code it is set to Cell[0,0]
Please find also the resulting pdf document as well as the sample code attached.
Thanks in advance
Erik