opening and amending an excel spreadsheet from filePro

Dennis Malen dmalen at malen.com
Thu Apr 22 07:52:14 PDT 2010


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 



More information about the Filepro-list mailing list