Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Acrobat 10 - Auto Import & Calculate From Excel

Status
Not open for further replies.
AugurTech

AugurTech

IS-IT--Management
Jun 15, 2011
2
US
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
 
Sort by date Sort by votes
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

 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Carol K
  • Locked
  • Question
Adobe Acrobat from SmartSheet
Replies
0
Views
770
Carol K
Carol K
SarahSCPDAdmin
  • Locked
  • Question
Adobe Acrobat Fillable Form with Checkbox and Values
Replies
2
Views
1K
SarahSCPDAdmin
SarahSCPDAdmin
avenel
  • Locked
  • Question
Disable Tools Pane in Adobe Acrobat Pro DC V21.007
Replies
0
Views
680
avenel
avenel
dpoag
  • Locked
  • Question
JavaScript in Acrobat Save As Found Text
Replies
1
Views
846
dpoag
dpoag
tombaraider
  • Locked
  • Question
Acrobat form field
Replies
2
Views
739
tombaraider
tombaraider

Part and Inventory Search

Sponsor

Back
Top