Excel VBA: opening a template file from an excel add in

Hi,

I have created a macro which opens a template file. The macro works fine from the workbook in which it is defined. Now I save the workbook as an Add in and register it in Excel. Then, I open a new workbook and from there the macro doesnt work..all the other macros in the add in works fine except for this one where in I open a template file using sheets.Add method.

Thanks
Kaizenn

To add more information, I have added the path where the template file is stored as a trusted path