Re: Copy to Excel Spreadsheet

[Ken.Slaugh@xxxxxxxxxx]

Write a macro in Excel to run the transfer. The automation can still be
achieved but I would change the query to output to a spoolfile file
instead, then use an ActiveX object to acquire the spoolfile. We do this
all the time and use our ActiveX AS/400 Objects,
http://www.cm-inc.com/AS400ole/ to process the data.

If you need more help or want a copy of an existing macro, eMail directly
and I'd be happy to send you what I can.

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/



                    Sunitha
                    Duraivelan               To:     rpg400-l@midrange.com
                    <sundurai2002@yah        cc:
                    oo.com>                  Subject:     Copy to Excel 
Spreadsheet
                    Sent by:
                    rpg400-l-admin@mi
                    drange.com


                    07/26/2002 02:08
                    AM
                    Please respond to
                    rpg400-l






--
[ Picked text/plain from multipart/alternative ]

Hi all,
I am looking to automate the process of downloading a query/400 outfile to
an Excel spreadsheet.
I am not sure if we can schedule the client access 'Data transfer from
AS/400' option to do the job automatically.
I am looking for a CL command to do this. Can anyone help me please.
Thanks,
Sunitha.




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.