Re: Output from PF to Excel XLS file in IFS

["trevor perry" <trevorp@xxxxxxxxxxxxxxxx>]

Lucky for me, the software I use has DDE built in. I can link to Excel, read
the data from the green screen or a DB2 file, and format it into Excel any
way I like - cells, columns, text, formulas.. everything. Then, I can tell
Excel to save it, and can attach to an email as I need.

It is not a batch process, but one driven by our GUI tool - however, the
users love that capability. I am currently working on replacing PC file
transfer with a generic transfer-into-Excel tool - I have almost finished
the one that generates HTML tables from DB2 files.

This led me to thinking, and I realized I can use VB very easily to DDE into
Excel in that same manner. And, VB can (slowly with ODBC) get to DB2 files.
If you want complete control of the Excel spreadsheet, this is a possible
solution.

----- Original Message -----
From: <meovino@estes-express.com>
Subject: Re: Output from PF to Excel XLS file in IFS


>
> Older versions may have done this, but newer versions will just open CSV's
> with no intervention.  Problem is, there's no way to format the cell as
> text in a CSV.  At least, that's my problem.
>
> Mike E.
>
>
>
>
>                     "Jerome Draper" <jdraper@trilosoft.com>
>                     Sent by:
To:     "Midrange Systems Technical Discussion" <midrange-l@midrange.com>
>                     midrange-l-bounces+meovino=estes-express.com@mi
cc:
>                     drange.com
Subject:     Re: Output from PF to Excel XLS file in IFS
>

>
>                     02/07/03 01:47 PM
>                     Please respond to Midrange Systems Technical
>                     Discussion
>
>
>
>
>
>
> I don't think that's the issue.  Excel opens .csv files but presents the
> parsing wizard so there's a process to complete before viewing the data in
> excel/.
>
> Jerry
>
> ----- Original Message -----
> From: Dennis Lovelady <dlovelady@dtcc.com>
> To: Midrange Systems Technical Discussion <midrange-l@midrange.com>
> Sent: Friday, February 07, 2003 9:58 AM
> Subject: RE: Output from PF to Excel XLS file in IFS
>
>
> >
> > Hmmmm....
> >
> >
> > Wouldn't it be simpler to just change the Winblows file association for
> > .CSV to open EXCEL?  Or is that too simplistic?
> >
> >
> > Dennis
> >
> >
> >
> >
> >
> > "Lim Hock-Chai" <Lim.Hock-Chai@arch.com>@midrange.com on 02/07/2003
> > 12:42:53 PM
> >
> > Please respond to Midrange Systems Technical Discussion
> >        <midrange-l@midrange.com>
> >
> > Sent by:    midrange-l-bounces@midrange.com
> >
> >
> > To:    "Midrange Systems Technical Discussion" <midrange-l@midrange.com>
> > cc:
> > Subject:    RE: Output from PF to Excel XLS file in IFS
> >
> >
> > The company I work for has the same problem of user do not want the file
> in
> > .csv format.  The reason is because when they double click on the
> > attachment it will not automatically open up the file in execl.
> >
> > Because the file view setting on most users pc is set to open any .dif
> file
> > using execl, I created a rpg program to convert the data into DIF format
> > and e-mail it to the users and they seems to be pretty happy with the
> > result.
> >
> > -----Original Message-----
> > From: Leland, David [mailto:dleland@Harter.com]
> > Sent: Friday, February 07, 2003 11:03 AM
> > To: 'Midrange Systems Technical Discussion'
> > Subject: RE: Output from PF to Excel XLS file in IFS
> >
> >
> > The something missing is: when you want to have it run unattended, maybe
> > even in batch, and not worry about a PC interface.
> >
> > -----Original Message-----
> > From: Johnson, Duane [mailto:djohnson@POWERMATE.com]
> > Sent: Friday, February 07, 2003 11:30 AM
> > To: 'Midrange Systems Technical Discussion'
> > Subject: RE: Output from PF to Excel XLS file in IFS
> >
> >
> >   OK, what am I missing here.  Is there some particular reason that you
> > don't want to use Client Access File Transfer?  I use it to create XLS
> > files, and it works great.
>
>
>
>
> _______________________________________________
> 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.
>
>