Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2020, 07:07 AM
reneemettrie reneemettrie is offline Location of the user templates Windows 10 Location of the user templates Office 2016
Novice
Location of the user templates
 
Join Date: Jan 2020
Posts: 16
reneemettrie is on a distinguished road
Default Location of the user templates


Is there a way in VBA tot find out the location of the user templates? Something that works on any PC...
Reply With Quote
  #2  
Old 01-06-2020, 05:00 PM
Logit Logit is offline Location of the user templates Windows 10 Location of the user templates Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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
Reply With Quote
  #3  
Old 01-06-2020, 11:15 PM
reneemettrie reneemettrie is offline Location of the user templates Windows 10 Location of the user templates Office 2016
Novice
Location of the user templates
 
Join Date: Jan 2020
Posts: 16
reneemettrie is on a distinguished road
Default

Quote:
Originally Posted by Logit View Post
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.
Reply With Quote
Reply

Tags
user templates

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Location of the user templates Location of New Templates Cyberseeker Word 4 06-20-2016 02:41 AM
Location of the user templates 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
Location of the user templates 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft