/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

1 vote171 views1 answer
Excel vba first row in range
VBA
0 vote164 views1 answer
Vba dropdown event
VBA
0 vote159 views1 answer
Vba copy paste value only
VBA
2 votes170 views2 answers
Excel vba copy values range to another range
VBA
0 vote175 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote170 views1 answer
Discern between file and folder given path vb.net
VBA
4 votes183 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote196 views1 answer
Vba search string position
VBA
0 vote189 views1 answer
Remove series name from legendvbnet
VBA
0 vote179 views1 answer
Find control with name vb
VBA