Merge multiple access reports to one pdf file using vba

Question

I wan't to merge multiple access reports to one pdf file using vba code. This vba code needs to work on the computers at my work. These computers only contain Adobe Reader, and I am not able to install Acrobat because I am not Administrator. So now my code generates for all the reports a seperate pdf. I had some code to merge these pdf files to one pdf file where I use 'Acrobat.CAcroApp'. But i get an error on line:

Set AcroApp = CreateObject("AcroExch.App")

I think I am not able to do this cause the computers only have Adobe Reader installed. Is there a possibility to create one pdf file for multiple reports/pdfs without using Acrobat.

Thx in advance

Tom Collins · Accepted Answer · 2014-08-21 03:31:44Z

3

2 solutions.

Make a master report that has each individual report embedded as a sub report. If it's just a few, it should work fine, but too many may bog down / crash the application.
Here's a VBA way of doing it here.

answered Aug 21, 2014 at 3:31

Tom Collins

4,0592 gold badges22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jens · Accepted Answer · 2014-08-20 11:36:20Z

2

Without acrobat reader this is indeed not going to work. I, however, am using the following dirty workaround for users without acrobat;

Export all your reports to rich text ("*.RTF" format) in the same folder. Afterwards, you open a word application via access vba, and loop through the RTF files and then copy them into your word file, with a page break after every insert. Then, you save the word document as a .PDF file.

This is a method prone to errors, so if a more experienced user has a better way, please do tell. I'm interested as well!

answered Aug 20, 2014 at 11:36

Jens

87913 silver badges34 bronze badges

1 Comment

Vinny Over a year ago

i will give this a try, this should work. thx for the fast response! And if someone has a more experienced way for doing this it is still welcome.

Collectives™ on Stack Overflow

Merge multiple access reports to one pdf file using vba

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related