Subject: How can I write a script to import some of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?
Subject: How can I write a script to import some of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?
easier way than using script is to just save the excel file to Lotus 1-2-3 format (WK4) and then use File > Import to import the data into a notes database as a document. Each row in the file will become a separate doc. Check notes help for more info on how to define the columns, etc…
Subject: How can I write a script to import some of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?
Some code like this will do the trick.
You need to define your db, and you have to loop through the rows and cols too.
Dim db As NotesDatabase
Dim doc As NotesDocument
Dim xlapp As Variant
Dim xlsheet As Variant
Dim row As Integer
Dim col As Integer
Dim cellvalue As String 'or some other type
Set xlapp = CreateObject(“Application.Excel”)
Set xlsheet = xlapp.Workbooks(1).Worksheets(1)
cellvalue = xlsheet.Cells(row, col).Value
Set doc = db.CreateDocument
Call doc.ReplaceItemValue(“”, cellvalue)