/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 vote203 views1 answer
How to set location and size of new from vb
VBA
1 vote183 views1 answer
Vba listindex select multiple items vba
VBA
0 vote163 views1 answer
Vbide vbproject reference
VBA
0 vote196 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote211 views1 answer
Vba test optional argument
VBA
0 vote251 views1 answer
Vbnet add axis labels to chart
VBA
0 vote200 views1 answer
How to make a if statement with vbs
VBA
0 vote216 views1 answer
Show unix time in vba
VBA
5 votes216 views1 answer
Xl vba double quotes in string literal
VBA
2 votes229 views2 answers
Excel vba if sunday or staurday
VBA