/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 vote151 views1 answer
How to extract a file from an ISO:
VBA
0 vote154 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote162 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote157 views1 answer
Vba full date format
VBA
0 vote160 views1 answer
Excel vba hide gridlines
VBA
3 votes148 views1 answer
Vba not equal
VBA
0 vote142 views1 answer
Le contrôle SpinButton (Toupie)
VBA
5 votes176 views2 answers
Excel vba write to the windows registry
VBA
0 vote171 views1 answer
Excel vba protect scenarios
VBA
2 votes151 views1 answer
Excel vba extract file name
VBA