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 |
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 |
All times are GMT +1. The time now is 10:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com