/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 vote221 views1 answer
Vba createparameter null
VBA
0 vote213 views1 answer
Vbnet add new ecel sheet
VBA
0 vote245 views1 answer
Vba find last column in a row with data
VBA
8 votes245 views1 answer
Run command pormpt in background windows
VBA
0 vote221 views1 answer
Refresh token em vb net
VBA
0 vote230 views1 answer
Vba variable number of arguments
VBA
0 vote260 views1 answer
Style percent not found vba
VBA
5 votes259 views1 answer
Excel vba low word from Long Integer
VBA
0 vote178 views1 answer
How to make a if statement with vbs
VBA
0 vote249 views1 answer
Set datetimepicker value to null vb
VBA