Open workbook with one worksheet 1

[Tiglet]

Hi,

How do I open new workbooks with just one worksheet in without changing the default SheetsInNewWorkbook property?

Tiglet

[green]Duct tape is like the force; it has a light side & a dark side, and it holds the universe together. [/green]

 

[combo]

With worksheet template:

[tt]Set wbk = Workbooks.Add(xlWBATWorksheet)[/tt]

combo

 

[Tiglet]

combo

Brill,

Have a star!

One question though, what does xlWBATWorksheet actually mean. I notice that rather than being called Book1 etc, the Workbook name is Sheet1. Makes no difference to my code, but I'm intrigued

Tiglet

[green]Duct tape is like the force; it has a light side & a dark side, and it holds the universe together. [/green]

 

[combo]

Hi Tiglet,
in Workbooks.Add(Template) (Template is optional), Template specifies, how the new workbook is created. If ommited, standard new workbook is added. You can specify file here to use it as a template. You can also use constants (sometimes enumerated):
1 - for worksheet (xlWBATWorksheet)
2 - chartsheet (xlWBATChart)
3 - macro sheet (xlWBATExcel4MacroSheet),
4 - international macro sheet (xlWBATExcel4IntlMacroSheet),
5 - workbook,
6 - module (with workbook),
7 -. old dialogsheet.
For instance, the syntax for dialogsheet is Workbooks.Add(7)

combo