opening and amending an excel spreadsheet from filePro

[John Esak]

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
>