Thread: Location of the user templates
View Single Post
 
Old 01-06-2020, 11:15 PM
reneemettrie reneemettrie is offline Windows 10 Office 2016
Novice
  
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