/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 vote171 views1 answer
Remove last 8 characters from string vb
VBA
0 vote133 views1 answer
Excel vba arrondir
VBA
25 votes343 views3 answers
String to date vb
VBA
0 vote187 views1 answer
Vba variable number of arguments
VBA
0 vote177 views1 answer
Show unix time in vba
VBA
4 votes186 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote181 views1 answer
Vba word open document read only
VBA
0 vote197 views1 answer
Excel vba protect scenarios
VBA
0 vote173 views1 answer
Vbs send keys
VBA
22 votes332 views1 answer
Xlvba check for folder
VBA