/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 vote153 views1 answer
Vbscript check if string contains
VBA
0 vote152 views1 answer
Tester si une case est vide vba
VBA
0 vote145 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote137 views1 answer
Excel vba prevent saving workbook
VBA
0 vote126 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote140 views1 answer
Vba word open document read only
VBA
0 vote134 views1 answer
Selecttoken em vbnet e json
VBA
0 vote136 views1 answer
Freeze panes vba
VBA
0 vote143 views1 answer
Excel vba protect worksheet without password
VBA
6 votes155 views1 answer
Excel vba isalpha
VBA