Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a formatted excel file with cell formatting plus an inserted bitmap
logo saved on my system as PO Template.xls Can I add a worksheet using that file as a template? Set newsheet = MasterWorkBook.Worksheets.Add("C:\Program Files\Bourret Tools\_POTemplate.xlt") 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?... It doesn't work for me! newsheet is still nothing after this line |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet Template | Excel Discussion (Misc queries) | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
Worksheet-template (HELP!) | Excel Programming | |||
Worksheet template | Excel Worksheet Functions | |||
Add worksheet as template | Excel Programming |