RE: Output from PF to Excel XLS file in IFS

Hmmm...this would have to be something like a long B/L number (an alpha
field) or a shipment number (FHSN?).  Let me check with one of my guys; I'm
sure we figured out a way to do this (but I might be wrong). 

Say hello to HBC III and RWE JR. for me...

-reeve

> -----Original Message-----
> From: midrange-l-bounces@midrange.com
[mailto:midrange-l-bounces@midrange.com] On Behalf Of
> meovino@estes-express.com
> Sent: Friday, February 07, 2003 1:24 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Output from PF to Excel XLS file in IFS
> 
> 
> > 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.
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.