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...