| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need template source path
I'm trying to find the path and name of the source .XLT
file that was used as the template for a worksheet. ThisWorkbook.Path is blank since the current workbook hasn't been saved yet (I use that fact to fake an AutoNew macro) but I'd like to know what .XLT was launched to create the current workbook. TIA Don DeCosta |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need template source path
Once you create the new workbook based on the template, that info is lost.
(It's quite different from MSWord.) Don DeCosta wrote: I'm trying to find the path and name of the source .XLT file that was used as the template for a worksheet. ThisWorkbook.Path is blank since the current workbook hasn't been saved yet (I use that fact to fake an AutoNew macro) but I'd like to know what .XLT was launched to create the current workbook. TIA Don DeCosta -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need template source path
It is different than Word in that respect and I would have like
to have a property which gave this info. One way round it would be to have code on the Template which held the template name which you add to it when you create the template. Chrissy. Once you create the new workbook based on the template, that info is lost. (It's quite different from MSWord.) Don DeCosta wrote: I'm trying to find the path and name of the source .XLT file that was used as the template for a worksheet. ThisWorkbook.Path is blank since the current workbook hasn't been saved yet (I use that fact to fake an AutoNew macro) but I'd like to know what .XLT was launched to create the current workbook. TIA Don DeCosta -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Source Data File Path Change | Excel Discussion (Misc queries) | |||
| Excel 2000: Changing path of an external data source | Excel Discussion (Misc queries) | |||
| Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
| Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
| how to change path name of html source folder ? | Excel Worksheet Functions | |||
Linear Mode
