/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 vote148 views1 answer
Excel named range sum
VBA
1 vote157 views1 answer
Excel vba autofit
VBA
5 votes176 views1 answer
Excel vba get user selected range
VBA
0 vote143 views1 answer
Vbnet line graph smooth lines
VBA
0 vote145 views1 answer
Vba code to open a file with login rights
VBA
0 vote136 views1 answer
Remove frist letter from string vbnet
VBA
3 votes143 views1 answer
Vba folderexists
VBA
0 vote150 views1 answer
Dynamic array vba
VBA
0 vote141 views1 answer
Change whcih control a user has selected vb
VBA
0 vote148 views1 answer
Vba get workbook name
VBA