Hi All,
I am need of finding a Template path.

The current Path of Template is "C:\Users\Me\Somewhere In Cloud\Location of Template\Template.xlt"

If I right click the Template and select open file then
OldPath = ActiveWorkbook.Path ' Returns "C:\Users\Me\Somewhere In Cloud\Location of Template\"


However if I double click the Template to open it, I get the following Results:

OldPath = Application.TemplatesPath 'Will return "C:\Users\Me\AppData\Roaming\Microsoft\Templates\"
OldPath = CurDir() ' Returns what ever path I happened to have saved an excel workbook in.
OldPath = ActiveWorkbook.Path ' Returns ""
OldPath = Application.ActiveWorkbook.path ' Returns ""

I need to have OldPath = "C:\Users\Me\Somewhere In Cloud\Location of Template\Template.xlt" Note this location will be different for every user

I will need my clients to be able to do either option. As you all know, people will double click!

Epscan