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 vote180 views1 answer
Vba excel parser xml
VBA
0 vote153 views1 answer
Thread sleep vb
VBA
0 vote138 views1 answer
Get current url vb.net
VBA
4 votes141 views1 answer
Excel vba how to reset usedrange
VBA
2 votes140 views1 answer
Excel vba check if key is in collection
VBA
0 vote139 views1 answer
Vba find sub dictionary
VBA
0 vote140 views1 answer
Excel vba disable keyboard input
VBA
1 vote132 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote135 views2 answers
Get excel file from email attachment in vba
VBA
0 vote166 views2 answers
Get unique random number in vb.net
VBA