/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

1 vote255 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote225 views1 answer
Excel protect cells with formulas
VBA
0 vote236 views1 answer
Vbs send keys
VBA
1 vote231 views1 answer
Excel vba get column name from number
VBA
0 vote250 views4 answers
Vgrive,deb
VBA
0 vote273 views1 answer
Excel vba urlmon
VBA
0 vote236 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote272 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote266 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
1 vote257 views1 answer
Vba optional
VBA