RE: getting spool file to MS Excel

[Ken Slaugh <ken.slaugh@xxxxxxxxxx>]

Carol
        As you wrote, 'There are many ways.'
        As many midrange users don't necessarily have source code to
make that 'quick mod'. The original Spoolfile may be all that is
available. You are correct that the Spoolfile itself would result in a
flat text format. The Spoolfile will never give packed or binary values
though. The macros within Excel can easily format the data. Even delete
the headings or convert them to Excel headings. My macros automate the
data retrieval, format the values, calculate results and print to the
printer. The AS/400 only needs to generate the data.

If you need an example, we at CMI use one monthly to print A/R bills. If
you want a copy of it email me at mailto:kens@cm-inc.com

Ken Slaugh
Programmer/System Analyst
Certified Network Administrator MSE
Specialist - Client Access/400

> -----Original Message-----
> From: Carol Bastien [SMTP:cabastien@home.com]
> Sent: Saturday, July 31, 1999 7:59 PM
> To:   RPG400-L@midrange.com
> Subject:      Re: getting spool file to MS Excel
> 
> Cagatay, 
> 
> There are many ways to move the spool file down to EXCEL, but I don't
> think you want to do that.  You would get an 80 position field that
> would be useless to your users.  The best thing to do is to make what
> should be a quick mod to the report program.  Create a physical file
> that contains all the fields (use same field names) written to the
> report in the detail line.  Add this file to your program as output
> and where ever the detail line is written to the report add a line of
> code to write to the new physical file.  Be sure to clear this file
> before calling the program.  When the program is done, simply use
> Client Access to transfer the file down to Excel.  Using that method
> you will retain the values of the fields in a usable format for your
> users. 
>   
> 
> Cagatay AZKIN wrote: 
> 
>        Hi, I have a lot of statistical Program and creates spool
> files. After printing the pages, Users enter all data to MS Excel
> File. My system version is 4.2 and Client Access version is 3.1.3 I
> connect to AS/400 with TCP/IP. Pls suggest Me ??Cagatay AZKIN 
> 
>   
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---END