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

Check out Workboooks.Add in XL/VBA Help.


In article ,
"Bing" wrote:

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 ?

And for adding sheets to an existing workbook:

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



JE McGimpsey wrote:

Check out Workboooks.Add in XL/VBA Help.

In article ,
"Bing" wrote:

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 ?


--

Dave Peterson

what sort of type is that? :-)

--

HTH

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


"Dave Peterson" wrote in message
...
And for adding sheets to an existing workbook:

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



JE McGimpsey wrote:

Check out Workboooks.Add in XL/VBA Help.

In article ,
"Bing" wrote:

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 ?


--

Dave Peterson

Template sort of type :-)
Adds all sheets in book1.xls

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I think that Bill Murray in Stripes may have answered:

Excel Type, Sir!



Bob Phillips wrote:

what sort of type is that? :-)

--

HTH

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

"Dave Peterson" wrote in message
...
And for adding sheets to an existing workbook:

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



JE McGimpsey wrote:

Check out Workboooks.Add in XL/VBA Help.

In article ,
"Bing" wrote:

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 ?


--

Dave Peterson

--

Dave Peterson