Dynamic range to PDF

[ImranBhatti]

Hi

I am looking Here but still confused which example should I use

Please Login or Register  to view this content.

My goal is to

1: Save a range that may expand or shrink with time , to PDF with high quality
2: Paper size A4
3: Should Automatically split to multiple pages if the number of rows exceeds 20 rows.
4: Copy should be named as "BalancesDDMMYYYY"
5: Saved in "Today's Reports" folder that is always on my Desktop.

Thanks in advance

Imran Bhatti


Note: In case of multiple pages it should show all pages into one file.

[torachan]

Best approach is possibly to construct a report template.
With a 'header' , 'body' & 'footer'.
Place your expanding data in the 'body' and use a linecounter to decide the number of pages.