Re: excel

There is a new book out by the Rochester Initiative  that is pricy ($495)
but gives great examples of the multiple ways to do what you want.  Go to
www.lab400.com and look for it...

Eric

----- Original Message -----
From: "Pete Olshavsky" <polshavsky@xxxxxxxxx>
To: <mapics-l@xxxxxxxxxxxx>
Sent: Monday, May 03, 2004 11:31 AM
Subject: excel


> 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
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>
>