/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

15 votes461 views1 answer
Excel vba wait
VBA
0 vote242 views1 answer
Vb.net change cursor to wait
VBA
0 vote217 views1 answer
Excel vba disable screen update
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA
0 vote233 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote226 views1 answer
Remove last 8 characters from string vb
VBA
4 votes216 views1 answer
Excel formula for last non-empty cell in a column
VBA
-1 vote244 views1 answer
Code for reading letters only in vb 6
VBA
0 vote228 views1 answer
Vba get application version
VBA
0 vote267 views1 answer
Vba code for cutoff time
VBA