Re: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

> forgive me for being flippant, but if the user 'absolutely, positively,
> will not accept anyting but an honest-to-god XLS file', and he/she
actually
> has the pull to make such an unreasonable mandate, tell him/her that the
> cost of purchasing SEQUEL will come out of her/his budget!  ;)

Unfortunately, not an option ;-)  I'm trying to get them to do the math to
justify the cost based on timesavings.  It will work out, but I'm not going
to do it for them.

> as far as other options - I've never done this, but can't you (at least
> 'semi') automate the process of importing external data (in this case, a
> .csv) into an excel template file, creating a new excel spreadsheet?
Maybe
> a VB macro, or some such.

CSV won't cut it; we're doing that right now.  Excel displays numbers with
more than 12 (?) digits in scientific notation, no matter how wide you make
the column.  It's a "feature."  I need to be able to format that column as
text.  If we wrap the value in double quotes with the CPYTOIMPF command,
Excel still treats the field as a number if there's no text in the field
(even blank spaces won't help).

VB macros are not an option.  We want to mail this out to customers, from a
program that runs on schedule in batch, with no human intervention.

Mike E.