/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 vote252 views1 answer
Excel vba first row in range
VBA
1 vote209 views2 answers
Vba string to date
VBA
5 votes240 views1 answer
Xlvba double quotes in string literal
VBA
8 votes369 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote251 views1 answer
Vbnet chart make 0 gridline line different color
VBA
3 votes244 views1 answer
Vba request json
VBA
1 vote221 views1 answer
What does vbs stand for
VBA
0 vote297 views1 answer
Excel vba add reference programmatically
VBA
1 vote222 views1 answer
Random number generator vb.net
VBA
0 vote269 views1 answer
Excel vba protect sheet
VBA