View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 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