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