/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 vote290 views1 answer
Excel vba copy range with filter
VBA
0 vote282 views1 answer
Excel filter by date not working vba
VBA
0 vote266 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote279 views1 answer
Build an index all files of a FTP site
VBA
3 votes279 views1 answer
Vba not equal
VBA
1 vote265 views1 answer
Excel format cell as kilowatts
VBA
0 vote298 views1 answer
Vbnet check if string is only letters
VBA
0 vote275 views1 answer
Vbnet check if string is only numbers
VBA
0 vote270 views1 answer
Excel protect cells with formulas
VBA
0 vote265 views1 answer
Vbnet check if number is even or odd
VBA