/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

1 vote233 views1 answer
Vba login website
VBA
1 vote250 views1 answer
Vb.net get name by Cell Click
VBA
0 vote207 views1 answer
Change "location" of binding navigator vb
VBA
1 vote227 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
5 votes252 views1 answer
Excel vba get user selected range
VBA
0 vote235 views1 answer
Excel vba prevent saving workbook
VBA
0 vote214 views1 answer
Vba createparameter null
VBA
0 vote212 views1 answer
Vbnet add new ecel sheet
VBA
0 vote245 views1 answer
Vbscript check if string contains
VBA
0 vote241 views1 answer
Remove first character from string vb
VBA