Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Worksheet from a template
Hi,
I have a template ,"Financial template", which contains around 30 worksheets . Assuming that I have workbook book1 open. Is it possible to insert an individual worksheet from "Financial template" into book1? Or do I have to create a workbook template for every worksheet in "Financial template" and then insert the workbook template representing the single sheet I want to add? I am using the code Sheet.add type:=<workbook template name to insert the templates. Is there a better way? Taher |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Worksheet from a template
Hi Taher,
I think the easiest thing to do would be to open the Financial template, copy the worksheet that you want into Book1, then close the template workbook without saving. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Taher Baderkhan" wrote in message ... Hi, I have a template ,"Financial template", which contains around 30 worksheets . Assuming that I have workbook book1 open. Is it possible to insert an individual worksheet from "Financial template" into book1? Or do I have to create a workbook template for every worksheet in "Financial template" and then insert the workbook template representing the single sheet I want to add? I am using the code Sheet.add type:=<workbook template name to insert the templates. Is there a better way? Taher |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop 'template help' from opening in a worksheet? | Excel Discussion (Misc queries) | |||
How to keep Help from popping up when opening doc from template? | Excel Discussion (Misc queries) | |||
Opening files with a template | Excel Discussion (Misc queries) | |||
Opening a Word Template from within Excel | Excel Worksheet Functions | |||
Template opening | Excel Discussion (Misc queries) |