/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

1 vote200 views1 answer
Sort using vba
VBA
0 vote191 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote172 views1 answer
Excel protect cells with formulas
VBA
0 vote194 views1 answer
Check if program is running vbnet
VBA
0 vote180 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote182 views1 answer
Vba option button selected
VBA
0 vote227 views1 answer
Wpf dark title bar
VBA
0 vote203 views1 answer
Excel vba protect sheet
VBA
0 vote180 views1 answer
Excel VBA web scraping
VBA
1 vote186 views1 answer
How to put a gridpain in a vbox
VBA