Re: Re: Output from PF to Excel XLS file in IFS

Things are not that simple in a (B TO B) or (B to C) World.  It really depend 
on your type of business and what type of customer you are dealing with.  
Especially, in todays tight market where you have competitors willing to 
fuilfil any customer need to have their business.  You don't have a choice, if 
the technology is available and the business can afford it.

Dare

-------Original Message-------
From: meovino@estes-express.com
Sent: 02/07/03 01:23 PM
To: Midrange Systems Technical Discussion <midrange-l@midrange.com>
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.

>