/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 vote344 views1 answer
Get current year vb
VBA
0 vote332 views1 answer
Excel vba delete folder
VBA
0 vote347 views1 answer
Vba html document reference
VBA
0 vote355 views1 answer
How to enter Vbox manage commands
VBA
0 vote330 views1 answer
Vba option button selected
VBA
1 vote353 views2 answers
Get all column names from excel vba
VBA
1 vote363 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote342 views1 answer
Vba collection contains
VBA
0 vote333 views1 answer
Vba type variable
VBA
0 vote339 views1 answer
Excel text to columns line break
VBA