Hi,
I’m looking for a way to export a predefined number of tabs into one pdf file i.e. My report has 7 tabs but only the first 3 must be exported into a pdf file.
When I use below code each tab is exported to a seperate pdf file
For i = 1 To 3
reps(i).ExportAsPDF ("C:\Temp\" & reps(i).Name & ".pdf")
Next i
Any solution to this?
Cheers.
Mister_E 
(BOB member since 2004-07-05)
Hi,
Have a look at the source code for this addin.
Best regards,
Mark
robbinma4 
(BOB member since 2005-07-31)
Hi Robbinma,
This is a nice peace of coding but doesn’t quite do what I need.
Here you have the option to export the enitire report to one file, each report to a seperate file or one tab to a file.
I need to export the the first 3 (of the 7) tabs of the report into 1 file.
Cheers.
Mister_E (BOB member since 2004-07-05)
Hi,
It would be a little awkward but have you considered:
Copying the first 3 tabs into a new report and then using the addin code to all three as one report.
I don’t think you can do what you want without an intermediate report as I don’t think there is a way to hide a report from the exporter.
Best regards,
Mark
robbinma4 (BOB member since 2005-07-31)
Mark,
Have considerd that, but wanted to do that as a last resort.
The report is big and complex, so want to avoid doing duplicate work in the future.
Mister_E (BOB member since 2004-07-05)
I think there are some utilities that can merge two or more pdf’s into one file. It’s the only solution I can think of, and I believe there are some tools mentioned on the forum.
Regards,
Gerard
https://bobj-board.org/t/36440 or https://bobj-board.org/t/49779
highandstoned 
(BOB member since 2005-08-01)
Thanks Gerard,
that would do the trick.
In fact I found a way of doing it also by deleting the tabs that do not need to be exported.
I have attached the script for those interested.
Export with tab deletions.txt (0.0 KB)
Mister_E (BOB member since 2004-07-05)