Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim NewOutputFile As Workbook
- Set NewOutputFile = Workbooks.Add(FileName & ".xls")
- NewOutputFile.Sheets.Add ("New tab")
- NewOutputFile.Sheets.Add().Name= "New tab"
- NewOutputFile.Sheets.Add(After:=NewOutputFile.Sheets(NewOutputFile.Sheets.Count)).Name = "New tab"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement