/VBA/Create new worksheet excel visual basic

Create new worksheet excel visual basic

Imports Excel = Microsoft.Office.Interop.Excel

Dim ExcelApp As New Excel.Application
Dim ExcelWorkBook As Excel.Workbook
Dim ExcelWorkSheet As Excel.Worksheet

ExcelApp.Workbooks.Open("ExcelFileName")
ExcelWorkBook = ExcelApp.ActiveWorkbook

PreviousSheetName = ExcelWorkBook.Sheets(ExcelWorkBook.Sheets.Count).Name

ExcelWorkBook.Sheets.Add(After:=ExcelWorkBook.Sheets(PreviousSheetName)).Name = "New Sheet Name"

Similar codes

0 vote173 views1 answer
Add text to Shape VBA
VBA
4 votes159 views1 answer
Excel vba how to reset usedrange
VBA
0 vote162 views1 answer
Ribbon show/hide
VBA
0 vote159 views1 answer
Vba string start with
VBA
0 vote153 views1 answer
Vba collection key list
VBA
20 votes332 views1 answer
Excel vba factorial
VBA
1 vote169 views1 answer
Add rows to datagridview vb.net
VBA
27 votes297 views2 answers
Vba check if file exists
VBA
1 vote168 views1 answer
Vbs run
VBA
5 votes179 views1 answer
Vba low byte from INTEGER
VBA