help with copying of excel spread sheet from template trought VB

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Guys/Ladies,

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

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

change ??? to the sheet name
 
Just a note to Patricks code. If Before:= or After:= is not specified, it
will create a new workbook.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Template with Updated Values Each Time 0
Excel Monthly Spread sheet. 12
Protect template worksheet 2
Excel template usage??? 5
Macro to copy multiple sheets x amount of times. 0
Excel Move or Copy Stopped Working? 0
Auto Populate a Template 5
Get date from prior sheet and add 7 days 6

Back
Top