View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Determining path to document template

The answer is that MSWord keeps track of this. Excel doesn't.



Angela wrote:

Hi,
Did you find out the answer since you've posted this question?
I'm having the same problem.
It's easy in Word, but it's missing in Excel.
Mail me if you know the solution:

Thanks

"PO" wrote:

Hi

Is there a way, using VBA, to determine from which template (name.xlt) a
workbook (xls) was created and where the template is located (path).

Regards
PO




--

Dave Peterson