/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 vote314 views1 answer
Vba shape transparent
VBA
0 vote326 views1 answer
Excel vba round to whole number
VBA
0 vote290 views1 answer
Enter into cells data grid view
VBA
0 vote341 views1 answer
Vba extract filename from path
VBA
1 vote319 views1 answer
Excel vba first row in range
VBA
0 vote358 views1 answer
Excel vba protect scenarios
VBA
1 vote304 views1 answer
Excel vba make cell visible
VBA
0 vote320 views1 answer
Vba check 32 or 64 bit
VBA
0 vote304 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote337 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA