Search field value in Lotus Notes to column value in Excel, before export value in Louts notes

HCL Domino Domino Forum
1

I searched forums, but not found what I am looking for.

I want to import excel report to Louts Notes database using Lotus script.

I need to do following

  1. I have two lotus notes databases FCR and FSS.

  2. I want to export Test document from FCR to FSS database.

  3. I have created a script which export Test document from FCR to FSS database.

  4. In FCR database I have a field ViewDispaly which contian unique number for each Test document i.e A.01.01.01, A.01.01.02, B.02.02.01, B.02.02.02

  5. I have Excel report which contain Column B same value as in Item# 4 (i.e ViewDisplay).

  6. what i need help is that when I export Test document from FCR to FSS database, I want to search FCR viewDisplay value to Excel Column B and once comparsion foucd the value in excel then import value from column C of excel to FSS Test document.

Thanks

Lisa

2

Subject: I hope this will help you…

Search the forums for the basics for loading an Excel spreadsheet using LotusScript and accessing the contents of worksheets. For your particular requirement, you can use the Find method of the Range object to locate the cell with the value you are interested in. For all the details on the Excel object model, look for reference pages on the MSDN site or the Excel VBA help file on your machine (it varies depending on what version you are using but it will be called something like VBAXL10.CHM).