How do I retrieve the absolute path of the default (per user) folder where Excel stores/looks for its template files?
(I need this for MS Office versions 2007, 2010, 2013 and 2016). Many thanks in advance. =S.Br.=
My PC does have that folder as well, but this is not where Excel 2010 stores its templates:
the default location is: %userprofile%\AppData\Roaming\Microsoft\Templates but user can
change it in ver.2010.
Thanks for reminding about the templatespath[/] property.
Earlier this afternoon I had visited the Microsoft Community website regarding this same question... Unless I misread some part of it, the answer was that, like the templates for the other MS Office 2013 apps, Excel 2013 is supposed to use C:\Username\Documents\Custom Office Templates.
My workstation's folder Custom Office Templates is empty, and my file Personal.xlsb shows up in C:\Username\AppData\Roaming\Microsoft\Excel\XLSTART. In my case, at least, that's working.
The User can select a place, by going into an open Excel file, then clicking File> Options> Trust Center > Trust Center Settings. Click the Add New Location button near the bottom of the dialog box. In the User Locations section, you can specify a place of your choice... I think.