Change worksheet in LS exporting to Excell

HCL Domino Domino Forum
1

how can i write cells in worksheet 2… 3… 4… etc etcin the follow way i write on ws1…

ù

…

Set excelSheet = excelNewWkbk.Worksheets(1)

excelSheet.Cells(1,1).value = “XXXX” …

thank you in advance

2

Subject: change worksheet in LS exporting to Excell

Change the WorkSheets(x) to 2?

Set excelSheet = excelNewWkbk.Worksheets(2)

excelSheet.Cells(1,1).value = “XXXX” …

3

Subject: RE: change worksheet in LS exporting to Excell

thenk you very much… :)do you know also how to set widht of column (if is possible) from LS?

thnks