export from filepro to an excel file

[Dennis Malen]

Thanks Don,

I'll look into that. That will save a little more time. The only problem is, 
that we are creating the excel file on the fly and are not exporting to a 
preformatted excel file that contains the macro.

Dennis

Dennis
----- Original Message ----- 
From: "Don Bush" <don at caffco.com>
To: "Dennis Malen" <dmalen at malen.com>; <filepro-list at lists.celestial.com>
Sent: Tuesday, March 14, 2006 6:12 PM
Subject: Re: export from filepro to an excel file


> We just create a macro in excel with a short key to reformat the columns 
> and what ever else
> we need.  user open the file in excel the press "ALT U"
>
>  At 04:11 PM 3/14/2006, Dennis Malen wrote:
>>I know this topic has been discussed before.
>>
>>We currently create an export file with:
>>
>>export multi exp=/tmp/bouncchk.xls r=1 f=1
>>
>>Even though we we add the extension ".xls" the file that is created is 
>>really SYLK (Symbolic Link).
>>
>>We use multi as opposed to comma delimited because if we are transferring 
>>a social security number that has a leading "0" it chops it off. That does 
>>not happen with multi. We FTP the file to our server and open the file in 
>>excel.
>>
>>The only problem we have with multi and comma delimited is that if we are 
>>transferring a number such as "37.50" excel picks up the number as "37.5". 
>>If we send "37.00" excel shows it as "37".
>>
>>We know that we can go into excel after the file is created and reformat 
>>the column as a decimal. Time is money and we don't want to have to do 
>>this.
>>
>>Does anyone know of any way to overcome this problem.
>>
>>We are on filePro 4.8 (going to 5.0 shortly) and on IBM AIX Unix.
>>
>>Thanks,
>>
>>Dennis Malen
>>516.479.5912
>>
>>_______________________________________________
>>Filepro-list mailing list
>>Filepro-list at lists.celestial.com
>>http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
>