| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying spread sheet | Excel Discussion (Misc queries) | |||
| Adding a new template spread sheet on the first day of a new month | Excel Discussion (Misc queries) | |||
| how do I make a template from an existing excel spread sheet? | Excel Worksheet Functions | |||
| spread sheet template for monthly business for a year | Excel Discussion (Misc queries) | |||
| Making a spread sheet template | New Users to Excel | |||
![Mike[_129_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
