/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 vote130 views1 answer
Docker vboxmanage not found
VBA
0 vote167 views1 answer
Excel vba first column in range
VBA
0 vote150 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote167 views1 answer
Excel vba protect shapes
VBA
0 vote167 views1 answer
Vba random number
VBA
1 vote149 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
12 votes261 views1 answer
Excel vba write string to text file
VBA
3 votes149 views1 answer
Excel insert blank row for value change in column
VBA
0 vote152 views1 answer
Vba variable number of arguments
VBA
0 vote145 views2 answers
How to concatenate more than 40 lines in vba
VBA