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 vote320 views1 answer
Vbnet check if string is only numbers
VBA
31 votes459 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote313 views1 answer
Change whcih control a user has selected vb
VBA
1 vote307 views1 answer
Excel vba first and last row and column in range
VBA
0 vote349 views1 answer
Vba boolean to string
VBA
0 vote355 views1 answer
Excel vba convert cells address
VBA
0 vote321 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote318 views1 answer
Vbscript Trim
VBA
22 votes472 views1 answer
Xlvba check for folder
VBA
1 vote321 views1 answer
Excel vba force recalculation
VBA