| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a new worksheet using a template or xls file
I have a formatted excel file with cell formatting plus an inserted bitmap
logo. Can I add a worksheet using that file as a template? VBA help says "If you are inserting a sheet based on an existing template, specify the path to the template. The default value is xlWorksheet." So is this valid?... Set newsheet = MasterWorkBook.Worksheets.Add(Type:="C:\Program Files\Bourret Tools\_POTemplate.xlt") It doesn't work! newsheet is still nothing after this line |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new worksheet from template for each value in range | Excel Worksheet Functions | |||
| Excel won't create file from template. What to do? | Excel Discussion (Misc queries) | |||
| create a master worksheet template | Excel Discussion (Misc queries) | |||
| Create a template for every worksheet | Excel Discussion (Misc queries) | |||
| want to create a template and update in seperate worksheet | New Users to Excel | |||
![John[_115_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
