I am looking for someway to take a series of different files (.dwf, .xls, Access Reports, etc.) and convert and compile them into one electronic file....such as a tif or pdf.
Does anyone know of any Apps that do this, that I can use with VBA or the VBA host App. (Access, Excel, Acad, etc.)??
Or is there a way to do this through VBA, directly or indirectly?
I know there are pdf converters for each program, but is there a universal method that works with any app.??
I want to eliminate having to print and send multiple copies of multiple files to multiple people. I know I could print it all out and scan it all to a tif, but I'd like to eliminate the printing (avg. 250 sheets per day) and also refrain from having to manually compile the files by scanning them. It seems that would not be much easier than faxing/mailing the printed sheets.