/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 vote182 views1 answer
Vba sort multiple columns
VBA
0 vote182 views1 answer
Vbnet find highest value in chart
VBA
4 votes196 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote206 views1 answer
Vbs exec hidden
VBA
0 vote185 views1 answer
Vba variable number of arguments
VBA
3 votes200 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote192 views1 answer
Excel vba unmerge sheet
VBA
0 vote193 views1 answer
Excel vba round to whole number
VBA
0 vote195 views1 answer
Send webhook vbscript
VBA
1 vote183 views1 answer
Excel vba autofit
VBA