/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 vote236 views1 answer
Vbs send keys
VBA
15 votes475 views1 answer
Excel vba wait
VBA
0 vote240 views2 answers
Get excel file from email attachment in vba
VBA
2 votes253 views1 answer
Excel vba extract file name
VBA
0 vote234 views1 answer
Excel vba disable mouse click
VBA
5 votes256 views1 answer
Vba low byte from INTEGER
VBA
0 vote261 views1 answer
Vba verticalalignment
VBA
0 vote233 views1 answer
Vbscript abs
VBA
0 vote231 views1 answer
Vb get ip address
VBA
0 vote230 views1 answer
Check range is in another range vba
VBA