Re: excel

Here's the CA 'plugin' by itself:  C:\Program Files\IBM\Client 
Access\Shared\cwbtfxla.xll

I may even have a program or two lying around it you like.  Although when 
we were doing
ODBC it was primarily thru Access.

Have fun!




Pete Olshavsky <polshavsky@xxxxxxxxx> 
Sent by: mapics-l-bounces+leleux=shur-lok.com@xxxxxxxxxxxx
05/03/2004 11:31 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
mapics-l@xxxxxxxxxxxx
cc

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.