"creating a new excel workbook" Code Answer

NewOutputFile.Sheets.Add().Name= "New tab"

Or if you want to add a Worksheet as the last Worksheet:

NewOutputFile.Sheets.Add(After:=NewOutputFile.Sheets(NewOutputFile.Sheets.Count)).Name = "New tab"
By Bob Goblin on August 3 2022

Answers related to “creating a new excel workbook”

Only authorized users can answer the Search term. Please sign in first, or register a free account.