I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs.
Currently I am using this method and it directs to the last saved(active) sheet.
Set xlsSheet = xlsWorkBook.ActiveSheet
I tired this method but got a Lotus Notes error 213.
Set xlsSheet = xlsWorkBook.Worksheets(1)
What method should I use?
November 1, 2007 5:08 PM
November 19, 2007 4:36 PM