/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 vote323 views1 answer
Vbscript check if string contains
VBA
0 vote334 views1 answer
Vbnet chart make 0 gridline line different color
VBA
8 votes494 views1 answer
Excel vba make word from bytes
VBA
0 vote340 views1 answer
Excel vba remove formatting from cell
VBA
1 vote311 views2 answers
Excel vba password protect
VBA
1 vote320 views1 answer
Excel vba last row of range
VBA
0 vote348 views1 answer
Reference to a non-shared member requires an object reference
VBA
1 vote358 views1 answer
How to put a gridpain in a vbox
VBA
7 votes352 views1 answer
Vba array declaration
VBA
0 vote324 views1 answer
Vba line feed
VBA