Location of the user templates

[reneemettrie]

Is there a way in VBA tot find out the location of the user templates? Something that works on any PC...

[Logit]

Excel File Extensions: XLSX, XLSM, XLS, XLTX, and XLTM

XLTX and XLTM
If an Excel file has either an XLTX or an XLTM extension, it is saved as a template file. Template files are used as starter files for new workbooks. Templates contain saved settings such as the default number of sheets per workbook, formatting, formulas, graphics, and custom toolbars. The difference between the two extensions is that the XLTM format can store VBA and XML macro code.

You can always search for all files with the template extension : *.XLTM

[reneemettrie]

Originally Posted by Logit

Excel File Extensions: XLSX, XLSM, XLS, XLTX, and XLTM



You can always search for all files with the template extension : *.XLTM

Sorry, I know all that. But that's not my question. I want to use the Workbooks.Add method and specify a template with a known name, but an unknown location, on any PC. Because the location of a User Templates is not the same on any PC in any company.
i thought about something such as the environ() function.