I have an objective that's been driving me in circles....
I need to figure out how to convert "multiple" Microsoft Access reports into one PDF file through VBA. Access 2007 has easy way to convert one report at a time to PDF, however, I cannot figure out how to access the Acrobat Distiller to convert multiple reports at once. There are several useful Add Ins that allow for "Multiple Report Conversion", but I would need someway of accessing the add ins DLL through VBA.
Does anyone have any suggestions or ideas?
Would be greatly appreciated...
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!