opening and amending an excel spreadsheet from filePro
Dennis Malen
dmalen at malen.com
Thu Apr 22 13:48:35 PDT 2010
John,
That is basically what we are doing except for the manual process of opening
up the excel spreadsheet and savings as a tab delimited file, then importing
into filePro. Exporting back out is not a problem but I wanted to try to
keep the original spreadsheet intact as the third party may or may not have
some unique formulas in the file. Those formulas would be lost once we
export back out to .csv with an .xls extension. Furthermore I am not aware
of how to implement the macros remotely.
Dennis Malen
516.479.5912
----- Original Message -----
From: "John Esak" <john at valar.com>
To: "'Dennis Malen'" <dmalen at malen.com>; <filepro-list at lists.celestial.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Thursday, April 22, 2010 3:09 PM
Subject: RE: opening and amending an excel spreadsheet from filePro
>I agree with Ken's suggestion. But, just curious... What you are doing now
> sounds like enough. What's wrong with it? I am not sure, but I think you
> can even name the .csv back to .xls... And it gets read in. Maybe not,
> but
> the .csv could automatically be read into Excel and then written out as a
> .xls and you could send that one? No? It's a long way around the horn,
> but
> it would work wouldn't it? That is if you dumping their .xls into a
> .csv....
> Reading it in, processing it, then writing back out a new .csv. The last
> step would be to read in that .csv into Excel and write it out in its
> native
> format? Macros could do all this pretty easily, right? I know we did
> miracles with word documents and the -m flag along with some carefully
> recorded macros. Assuming Excel's macro recorder is the same as the one
> in
> Word, which it must be.
>
> John
>
>> -----Original Message-----
>> From: filepro-list-bounces+john=valar.com at lists.celestial.com
>> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Dennis Malen
>> Sent: Thursday, April 22, 2010 10:52 AM
>> To: filepro-list at lists.celestial.com
>> Subject: opening and amending an excel spreadsheet from filePro
>>
>> We have the need to modify an excel spreadsheet received by
>> third parties.
>> Within the spreadsheet received from the third party is
>> enough information
>> to search for a filePro record. What we would like to do is to create
>> processing that seamlessly opens the excel spreadsheet, looks
>> up the record
>> in filePro and then places the appropriate information in a
>> specific column
>> and line and closes the file ready to return to the third party.
>>
>> What we do now is create tab delimited file from the excel
>> spreadsheet,
>> import that into a filepro file, do the lookups and then export the
>> information in a .csv file and return to the third party.
>>
>> Any thoughts or help would be appreciated.
>>
>> Dennis Malen
>> 516.479.5912
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
More information about the Filepro-list
mailing list