Re: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

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.