/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 vote134 views4 answers
How to continue formula in below line in vba code
VBA
0 vote125 views1 answer
Vbscript for loop
VBA
1 vote135 views1 answer
Excel vba force recalculation
VBA
1 vote119 views1 answer
Excel vba to lower case
VBA
1 vote131 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote136 views1 answer
Delete rows in excel vba code
VBA
0 vote137 views1 answer
Vba dictionary clear
VBA
0 vote135 views1 answer
VBA Loop to range
VBA
0 vote125 views1 answer
Excel vba select multiple shapes
VBA
0 vote126 views1 answer
Vba get text file content
VBA