RE: excel

["Susanne States" <sstates@xxxxxxxxxxxxxxx>]

Pete,
There are third party products out there that do this if the solutions
you try don't work for you. Here's one
http://www.solution400.com/S4iExpressProductDetails.html


-----Original Message-----
From: mapics-l-bounces+sstates=solution400.com@xxxxxxxxxxxx
[mailto:mapics-l-bounces+sstates=solution400.com@xxxxxxxxxxxx] On Behalf
Of Pete Olshavsky
Sent: Monday, May 03, 2004 11:32 AM
To: mapics-l@xxxxxxxxxxxx
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.