RE: Copy to Excel Spreadsheet

[Portal39@xxxxxxx]

--
[ Picked text/plain from multipart/alternative ]
HAS THIS  BEEN TESTED or JUST a THOUGHT

A. Ports
----------------------------------------------------------------------
From: "Tanveer, Mohammad" <mtanveer@crateandbarrel.com>
To: "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
Subject: RE: Copy to Excel Spreadsheet
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
content-transfer-encoding: 7bit
content-type: text/plain;
 charset=iso-8859-1
Sender: rpg400-l-admin@midrange.com
Errors-To: rpg400-l-admin@midrange.com
X-BeenThere: rpg400-l@midrange.com
X-Mailman-Version: 2.0.12
Precedence: bulk
Reply-To: rpg400-l@midrange.com
List-Unsubscribe: <<A 
HREF="http://lists.midrange.com/cgi-bin/listinfo/rpg400-l";>http://lists.midrange.com/cgi-bin/listinfo/rpg400-l</A>>,
        <<A 
HREF="mailto:rpg400-l-request@midrange.com%3Fsubject=unsubscribe";>mailto:rpg400-l-request@midrange.com?subject=unsubscribe</A>>
List-Id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-Post: <<A 
HREF="mailto:rpg400-l@midrange.com";>mailto:rpg400-l@midrange.com</A>>
List-Help: <<A 
HREF="mailto:rpg400-l-request@midrange.com%3Fsubject=help";>mailto:rpg400-l-request@midrange.com?subject=help</A>>
List-Subscribe: <<A 
HREF="http://lists.midrange.com/cgi-bin/listinfo/rpg400-l";>http://lists.midrange.com/cgi-bin/listinfo/rpg400-l</A>>,
        <<A 
HREF="mailto:rpg400-l-request@midrange.com%3Fsubject=subscribe";>mailto:rpg400-l-request@midrange.com?subject=subscribe</A>>
List-Archive: <<A 
HREF="http://archive.midrange.com/rpg400-l/";>http://archive.midrange.com/rpg400-l/</A>>
Date: Fri, 26 Jul 2002 09:11:19 -0500

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 [<A 
HREF="mailto:sundurai2002@yahoo.com";>mailto:sundurai2002@yahoo.com</A>]
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.