/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

3 votes314 views1 answer
Excel vba make long from two shorts
VBA
0 vote305 views1 answer
Date as number vb
VBA
0 vote284 views1 answer
Excel vba center userform
VBA
0 vote318 views1 answer
Style percent not found vba
VBA
2 votes237 views1 answer
Excel vba pause
VBA
0 vote266 views1 answer
Excel autofilter vba
VBA
0 vote288 views1 answer
Vba timestamp -- milliseconds
VBA
4 votes292 views2 answers
Excel vba last column with data
VBA
0 vote296 views1 answer
Excel vba cell on change
VBA
0 vote275 views1 answer
Vbnet check if string is only symbols
VBA