/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 vote217 views1 answer
Le contrôle SpinButton (Toupie)
VBA
5 votes226 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote217 views1 answer
Vb net check if file exists
VBA
0 vote217 views1 answer
Vba paste values
VBA
-1 vote249 views1 answer
Code for reading letters only in vb 6
VBA
0 vote226 views1 answer
Regex numeric digits
VBA
1 vote243 views1 answer
Vba format string as cash
VBA
0 vote224 views1 answer
Vba border weight
VBA
0 vote229 views1 answer
Enable macros on opening workbook vba
VBA
0 vote225 views1 answer
Type excel.application is not defined vb
VBA