RE: Copy to Excel Spreadsheet

Best way to automate this task is through PC, If you know PC just write
simple VB program or a macro which will check a dataque on AS/400 and will
download the file in your Excel format or any other format (great XML :) )


Write a flag in the dataque which will trigger the VB program to start
downloading the file.  Interesting hum   :)



 -----Original Message-----
From:   Sunitha Duraivelan [mailto:sundurai2002@yahoo.com]
Sent:   Friday, July 26, 2002 4:08 AM
To:     rpg400-l@midrange.com
Subject:        Copy to Excel Spreadsheet

--
[ 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.