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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: