How to active Excel Sheet One By One Through Lotus Script

HCL Domino Domino Forum
1

Hello i have problem , actually i read the data from Excel sheet (In Perticular Sheet) but i want to active another sheeet also in same Excel file but i am not able to do that

If any one know how to active Excel Sheet one by one through Lotus Script then pls help me.

2

Subject: How to active Excel Sheet One By One Through Lotus Script

Initiate the worksheets as

Set Vntxlsheet = Vntxlapp.workbooks(1).Worksheets(1)

Set Vntxlsheet1 = Vntxlapp.workbooks(1).Worksheets(2)

Where Vntxlapp is Excel Object.

Use Vntxlsheet1.Activate or Vntxlsheet.Activate to shift between the sheets.