/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 vote172 views1 answer
Vba sendkeys
VBA
0 vote158 views1 answer
Change "location" of binding navigator vb
VBA
3 votes162 views1 answer
Excel vba read registry key value
VBA
0 vote180 views1 answer
Vba min
VBA
0 vote194 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote166 views1 answer
Make all controls in an area not visable vb
VBA
7 votes171 views1 answer
Vba array declaration
VBA
1 vote177 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote173 views1 answer
Check if program is running vbnet
VBA
0 vote162 views1 answer
Handling a click event anywhere inside a panel vb
VBA