help with copying of excel spread sheet from template trought VB
 

Guys/Ladies,

I need to copy template sheet in the work book with VB.
Anubody help??

Mike

help with copying of excel spread sheet from template trought VB
 

dim ws as worksheet
set ws = thisworkbooks.worksheets("???")
ws.copy

change ??? to the sheet name

"Mike" wrote in message
...
Guys/Ladies,

I need to copy template sheet in the work book with VB.
Anubody help??

Mike

help with copying of excel spread sheet from template trought VB
 

Just a note to Patricks code. If Befo= or After:= is not specified, it
will create a new workbook.



"Patrick Molloy" wrote in message
...
dim ws as worksheet
set ws = thisworkbooks.worksheets("???")
ws.copy

change ??? to the sheet name

"Mike" wrote in message
...
Guys/Ladies,

I need to copy template sheet in the work book with VB.
Anubody help??

Mike