Location of the user templates

reneemettrie · #1 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