RE: Excel

["Raby, Steve \(GE Advanced Materials, consultant\)" <steve.raby@xxxxxx>]

Hello Mike,

Something like this, it works for me.

                                                            
  CPYTOIMPF  FROMFILE(LIBOBJ/filename) +       
               TOSTMF('directory/Update_file.csv') +           
               MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +      
               RCDDLM(*CRLF) STRDLM(' ') FLDDLM(',')        
                                                          

Steve  

-----Original Message-----
From: midrange-l-bounces+steve.raby=ge.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+steve.raby=ge.com@xxxxxxxxxxxx]On Behalf Of
Mike Berman
Sent: Tuesday, August 03, 2004 2:22 PM
To: Midrange Systems Technical Discussion
Subject: Re: Excel


Carel, So I have a CL that first creates the file.
 
PGM
CAll RPGPGM
 
Then: 
 

Carel Teijgeler <coteijgeler@xxxxxxxxx> wrote:
Mike,

CPYTOIMPF; this will generate a csv-file, that can easily be opened in Excel.

Have the users map to the IFS as well. 

Why take difficult routes, when it can be that easy? 

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 30-7-04 at 13:11 Mike Berman wrote:

>What is the easiest way to run a CL that creates a file, send this file to the 
>users share drive as an Excel spreadsheet. I am personally not interested in 
>any commercial products.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


                
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.