/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 vote166 views1 answer
Send text to clipboard vb.net
VBA
3 votes162 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote161 views1 answer
Excel vba scroll to cell
VBA
0 vote162 views1 answer
How to use if condition in time vba
VBA
0 vote165 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote178 views1 answer
Thread sleep vb
VBA
0 vote160 views1 answer
Vbnet check if string is only symbols
VBA
0 vote167 views1 answer
Excel vba unmerge sheet
VBA
0 vote170 views1 answer
Vba format currency
VBA
0 vote179 views1 answer
Vba count all row
VBA