×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Acrobat 10 - Auto Import & Calculate From Excel

Acrobat 10 - Auto Import & Calculate From Excel

Acrobat 10 - Auto Import & Calculate From Excel

(OP)
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

RE: Acrobat 10 - Auto Import & Calculate From Excel

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

  

RE: Acrobat 10 - Auto Import & Calculate From Excel

(OP)
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

RE: Acrobat 10 - Auto Import & Calculate From Excel

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

  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close