/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 vote122 views1 answer
Vba text to general
VBA
0 vote110 views1 answer
Vbnet add new ecel sheet
VBA
1 vote119 views1 answer
Excel vba get column name from number
VBA
0 vote124 views1 answer
Send text to clipboard vb.net
VBA
0 vote135 views1 answer
Test if form is open vb
VBA
0 vote123 views1 answer
Vba code to select image in sheet
VBA
0 vote130 views1 answer
Vba table header name
VBA
0 vote137 views1 answer
Vb run command
VBA
0 vote127 views1 answer
Find database connection string vb
VBA
0 vote126 views1 answer
Get current url vb.net
VBA