what was name of that function/method??

[Guest]

I can't recall but there is a function (I think?) that can open or create a
workbook/or worksheet based on an existing template. Does anyone recall that
function name ?

Thanks
Bing

 

[JE McGimpsey]

Check out Workboooks.Add in XL/VBA Help.

 

[Dave Peterson]

And for adding sheets to an existing workbook:

Sheets.Add Type:="C:\my documents\excel\book1.xls"

 

[Bob Phillips]

what sort of type is that?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Sharad]

Template sort of type
Adds all sheets in book1.xls

Sharad

 

[Dave Peterson]

I think that Bill Murray in Stripes may have answered:

Excel Type, Sir!