Determining path to document template
 

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

Determining path to document template
 

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

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