/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 vote188 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote156 views1 answer
How to make a if statement with vbs
VBA
0 vote167 views1 answer
Change "location" of binding navigator vb
VBA
0 vote181 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote185 views1 answer
Vba loop through textboxes
VBA
0 vote193 views1 answer
Vba DisplayGridlines
VBA
1 vote172 views1 answer
Close form vba
VBA
0 vote187 views1 answer
Vba paste values
VBA
0 vote170 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote179 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA