excel

[Pete Olshavsky <polshavsky@xxxxxxxxx>]

Happy Monday Group. 
Not sure there is an easy or simple answer.
Has anyone figured out in EXCEL the transfer from AS/400??? (Client Access 
express 5.1).. 
Is there good documentation with examples anywhere????? I am not very skilled 
with excel.. Which is probably issue one.
What I am trying to do, is create an excel spreadsheet with data I generated on 
the as400 via a pgm that will get run once a week.  I would then like the user 
to click an icon, and the data would get transfered / replaced to a spreadsheet 
that was created and saved. And retain all the changes that I have setup in the 
spreadsheet. 
 
                                    inp dte+7  +7            +7
 COMNO   Input date     99/99/99    99/99/99   99/99/99   <---     HEADINGs
  01           05/03/04       dollrs          dollars     dollrs       <---  
Data from 400
The Input date fld would be used to calc the date that is 7 days, then 7 more 
days, then 7 more days, etc.

                
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs