| |
You are here: Experts > Internet/Online > Email > Using Lotus Notes > Compare values between excel and a notes db
Expert: Paski K. Paskaradevan
Date: 8/12/2008
Subject: Compare values between excel and a notes db
Question
Hello,
I have a database in Notes call GoldMine.nsf with a view call Clients and I have one excel file call ExtraClients.xls. Both file have the following information:
ClientName Email
Carlos R. carlosRJ@hotmail.com
Stephen P. stephenP@aol.com
I need to compare the existing information on the database against the .xls field.
Could you please help me? I have no clue how to do it.
Answer
Hi,
You need to write a lotus script agent to read the cells in the excel spread sheet. You can do this by recording macros in the spread sheet and using the methods you find in the macros. Then you can compare the values.
I think there are many examples of excel reading code on the internet.
Sorry, I do not write code in this forum.
Regards.
Paski
Add to this Answer
Ask a Question
|
|
