Re:Excel

We use several reports that get data from the AS/400 since most of our
managers love Excel and hate paper reports.

I create a query in MS Query (it comes on the Office disk but I don't think
that it is installed by default).  Once you setup your ODBC drivers to
access the correct library on you AS/400, you can enter an SQL statement or
just create it in MS Query.  When you return the data to Excel, everything
that you selected will be there.

Using this approach I use VBA to run the previously created query and also
to format the spreadsheet.  You can also create dialog boxes in VBA to pass
parameters to the query such as Dates or Warehouses.  The VBA code is
executed by clicking a button on the spreadsheet.

Tom Hamilton
Systems Coordinator
Allied-Baltic Rubber, Inc.


message: 1
date: Mon, 3 May 2004 11:31:35 -0700 (PDT)
from: Pete Olshavsky <polshavsky@xxxxxxxxx>
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 

------------------------------