/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 vote401 views1 answer
Open file dialog in vb.net
VBA
0 vote390 views1 answer
Excel named range sum
VBA
0 vote400 views1 answer
Pivot data source not accepting table named range vba
VBA
3 votes388 views1 answer
Vba make long from two words
VBA
0 vote323 views1 answer
Add items to combobox vb.net
VBA
0 vote387 views1 answer
Excel vba combine ranges
VBA
0 vote344 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote481 views1 answer
Wpf dark title bar
VBA
0 vote364 views1 answer
Excel vba calculate
VBA
0 vote357 views2 answers
Vba remove line breaks
VBA