path to Excel template folder

[S.Br.]

Dear All;
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.=

 

[Logit]

.
I have Excel 2007 (32 bit / Win 10 64 bit).

The Templates are stored at : C:\Program Files (x86)\Microsoft Office\Templates\1033

 

[S.Br.]

Thanks Logit.
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.

 

[Logit]

My computer has your path as well but it is empty.

 

[jimrward]

Have you looked at vba and tried msgbox application.templatespath, you could store this mytemplates=application.templatespath

Try googling it will throw up more examples

 

[S.Br.]

Jim, you just made my day. Many thanks and have a great weekend!
S.Br.

 

[JohnS]

Have you looked at vba and tried msgbox application.templatespath, you could store this mytemplates=application.templatespath

Try googling it will throw up more examples

jimrward:

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.

Thanks,
JohnS