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