Vbnet add new ecel sheet

Dim ExcelWorkSheet As Excel.Worksheet = CType(ExcelWorkBook.Sheets.Add(Count:=1), Excel.Worksheet)
'Add(Count:=1) means that 1 additional sheet is added, on top of the existing sheet that is automatically generated

'This defines the sheets sperately, so they may be manipulated
Dim ExcelWorkSheetPasswords As Excel.Worksheet = CType(ExcelWorkBook.Sheets(1), Excel.Worksheet)
Dim ExcelWorkSheetArchive As Excel.Worksheet = CType(ExcelWorkBook.Sheets(2), Excel.Worksheet)

Similar codes

0 vote344 views1 answer
How to add line graph vb net
VBA
0 vote344 views1 answer
Vba open report
VBA
0 vote343 views1 answer
Vba createparameter null
VBA
0 vote357 views1 answer
Vba integer to double
VBA
0 vote332 views1 answer
Compare dates vb
VBA
0 vote316 views1 answer
Check if program is running vbnet
VBA
0 vote332 views1 answer
Remove frist letter from string vbnet
VBA
0 vote341 views1 answer
Vba leading zeros in string
VBA
0 vote361 views1 answer
Find if year is leap year vb
VBA
0 vote341 views1 answer
Vba collection key list
VBA