/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 vote310 views1 answer
Vba first cell in range
VBA
4 votes323 views2 answers
Vba last row
VBA
0 vote293 views1 answer
Vba dropdown event
VBA
3 votes326 views1 answer
Vba make long from two words
VBA
0 vote315 views1 answer
Vba sheet hide unhide
VBA
0 vote306 views1 answer
Vbscript check if string is empty
VBA
0 vote304 views1 answer
Internet explorer reference vba
VBA
0 vote298 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote315 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote330 views1 answer
Open file dialog in vb.net
VBA