Getting the filepath of a template

  • Thread starter Thread starter Boing Boing Dave
  • Start date Start date
B

Boing Boing Dave

I have a template which is to be distributed across various networks. When
the template is launched I need to be able to get the filepath of the
original template to subsequently read an ini file.
In Word this is 'ActiveDocument.AttachedTemplate' but can anyone tell me how
to do this in Excel please?
 
ActiveWorkbook.Path

assuming the template is the active workbook

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks Bob, but that only works if the workbook has been saved. I need to do
some calculations based on data in the ini file which will be in the same
folder as the template.
 
Excel doesn't keep track of the template location like MSWord does.

Maybe you can just ask the user the location?
 
or save the filepath of the template in an Excel name and query that?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top