Location of the user templates

reneemettrie · #1 01-06-2020, 07:07 AM

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

Logit · #2 01-06-2020, 05:00 PM

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

Quote:

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 · #3 01-06-2020, 11:15 PM

Quote:

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Location of New Templates	Cyberseeker	Word	4	06-20-2016 02:41 AM
Creating templates that ask for the users location	Panzer336	Word	3	10-11-2014 09:34 PM
Office 2010 change location workgroup templates appear in from My Templates folder	nickc	Word	0	11-20-2013 03:38 AM
Word 2010 - Different Save Location for Different Templates?	RDKells	Word	8	05-25-2012 11:03 AM
Multi location templates	James m	Outlook	0	05-23-2012 06:53 PM