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 vote199 views1 answer
Visual basic msdos
VBA
5 votes207 views1 answer
Excel formula how to create strings containing double quotes
VBA
3 votes237 views2 answers
Vba date to string
VBA
0 vote192 views1 answer
Vba find last column in a row with data
VBA
0 vote216 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote229 views1 answer
.net crash app
VBA
0 vote212 views1 answer
Vba apostrophe chr
VBA
0 vote206 views1 answer
Rotate image by any angle vb.net
VBA
0 vote143 views1 answer
Vba select file in folder
VBA
0 vote213 views1 answer
Arq linux
VBA