/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 vote156 views1 answer
Vba set vs dim
VBA
0 vote226 views1 answer
Vba horizontalalignment
VBA
2 votes204 views1 answer
Vba file from path
VBA
0 vote203 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote201 views1 answer
Vbnet get file name from path
VBA
0 vote223 views1 answer
Excel vba protect sheet
VBA
1 vote235 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote196 views2 answers
Excel vba close without saving
VBA
0 vote194 views1 answer
Vba dropdown event
VBA
0 vote235 views1 answer
Visual basic cmd
VBA