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 vote115 views1 answer
Create new worksheet excel visual basic
VBA
0 vote128 views1 answer
Convert unix to date vba
VBA
0 vote154 views1 answer
Windows Forms dark title bar
VBA
0 vote122 views1 answer
Open file dialog in vb.net
VBA
5 votes139 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote108 views1 answer
Excel vba open browser
VBA
0 vote131 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote119 views2 answers
How to concatenate more than 40 lines in vba
VBA
25 votes181 views3 answers
String to date vb
VBA
3 votes140 views2 answers
Vba date to string
VBA