I am using Calc with basic - macro, which work well with pdf export.
(It is like mail merge using calc only.)
dispatcher.executeDispatch(document, ".uno:ExportDirectToPDF", "", 0, args1()) Next rollno End Sub
(This is the last few lines of the macro to export calc range as pdf.)
My macro have loop and it changes value of range and then export (the template/result sheet) to a separate pdf. (similar to mail merge but here only and only calc is doing all.)
Now I want to append all (i.e. export of n number loop) and export them to a single pdf.
I tried every possible way but nothing work (I have limited knowledge of basic - macro, I use copy - paste + change/trial and error method).
- append cell range using insert or copy - paste method, using them as object.
- export to a new calc sheet (or a new file) and append all exported data in it and then export it as pdf.
- your suggestions…
Here is sample mail merge.
P.S. Helpful Section
Thanks in advance,