/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 vote261 views1 answer
Vba horizontalalignment
VBA
0 vote333 views1 answer
Vba array of integers
VBA
5 votes284 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote251 views1 answer
Ribbon show/hide
VBA
0 vote250 views1 answer
Vba remove numbers from string
VBA
0 vote237 views1 answer
Vbnet line chart showing extra space
VBA
2 votes271 views2 answers
Excel vba if sunday or staurday
VBA
3 votes249 views1 answer
Vba not equal
VBA
8 votes300 views1 answer
Excel vba make word
VBA
0 vote254 views1 answer
Excel vba copy range with filter
VBA