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 vote372 views2 answers
Checking and changing system volume vb.net
VBA
0 vote350 views1 answer
Excel vba show developer tab
VBA
1 vote344 views1 answer
Close form vba
VBA
1 vote394 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote369 views1 answer
Weekday vba
VBA
0 vote376 views1 answer
Send text to clipboard vb.net
VBA
0 vote455 views1 answer
Vba vbcrlf chr
VBA
0 vote342 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote345 views1 answer
Vba get text file content
VBA
18 votes570 views2 answers
Vba make word from bytes
VBA