Acrobat 10 - Auto Import & Calculate From Excel

[AugurTech]

Greetings!

I work for a manufacturing company that currently moves data from a custom Lotus Notes database into a Microsoft Excel spreadsheet. The existing solution takes the data from the spreadsheet and funnel's it through a custom form software on an AS400. The form software then outputs the data & form to a network printer which produces 4 copies.

The form software on the AS400 is expiring and the company does not plan to renew. Additionally, the form software is severely antiquated and buggy. The company has tasked me with leveraging our current licenses for Adobe Acrobat 10 to import the data from Excel and output to the network printer and produce 4 copies.

Can someone guide me or direct me to a resource so that I can produce this solution.

Thanks in advance for any assistance you can offer.

Mark

 

[FredWagner]

Have you opened the spreadsheet in Excel and tried formatting it yourself yet ? You should be able to do that (assistance in the Excel forum if needed), then from inside Excel, print the copies directly, or save the formatted file in Excel, save as PDF, and then print. You probably don't need to use Acrobat at all, just do the whole process in Excel, automate it with a macro or two.

Fred Wagner

 

[AugurTech]

Fred,

Thanks for the advice. I completely overlooked the Excel avenue. I thought there should be a simpler and more direct way of producing the end result and there it was stairing me in the face.

I will post the information in the Excel forum today.

Thanks again,

Mark

 

[FredWagner]

Mark - Sometimes the 'obvious' isn't.... been there ! If you're in a time crunch on this, you might need to get an Excel artist/expert to set up the formatting and macros for you. If you have the time to do it yourself, it will be a valuable learning experience. Be aware of the different features and interface quirks in the various versions of Excel. Good luck!

Fred Wagner