/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 vote223 views1 answer
Vbscript convert ascii code to character
VBA
0 vote256 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote221 views1 answer
Excel run macro every 5 minutes
VBA
18 votes557 views2 answers
Vba make word from bytes
VBA
0 vote219 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote229 views1 answer
Convert number to minutes in vba
VBA
0 vote223 views1 answer
Nested if else in vb.net
VBA
0 vote224 views1 answer
Excel vba extract year
VBA
0 vote218 views2 answers
Excel vba close without saving
VBA
0 vote222 views1 answer
Remove series name from legendvbnet
VBA