/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 vote365 views1 answer
Vba listbox remove all items
VBA
8 votes414 views1 answer
Excel vba make integer
VBA
1 vote379 views1 answer
Export datagridview to excel vb.net
VBA
0 vote387 views1 answer
Vba count all row
VBA
0 vote361 views1 answer
VBA Loop to range
VBA
1 vote339 views1 answer
If inputbox cancel vba
VBA
1 vote375 views1 answer
Vba ubound array 2-dimensional
VBA
13 votes488 views2 answers
Vba write text file
VBA
0 vote377 views1 answer
Tester si une case est vide vba
VBA
0 vote408 views1 answer
Excel vba unmerge sheet
VBA