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