/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 vote276 views1 answer
Vba border weight
VBA
0 vote294 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote290 views1 answer
Get current year vb
VBA
1 vote292 views1 answer
Vbs run
VBA
0 vote269 views2 answers
Excel vba prevent save
VBA
0 vote291 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
1 vote269 views2 answers
Excel vba password protect
VBA
0 vote268 views1 answer
Quit excel with save changes dialog vb.net
VBA
5 votes329 views1 answer
Excel vba get user selected range
VBA
8 votes410 views1 answer
Excel vba make word from bytes
VBA