RagDyer
Mon Mar 10 15:20:48 CDT 2008
There are a couple of relatively simple ways to get that info.
*Before* you even create the template, when you click on "Template (*.xlt)",
in the "Save As Type" box, you'll notice that in the "Save In" box, at the
top of the window, the folder "Templates" is displayed.
Expand this box by clicking on the tiny arrow on the right side, and you'll
get a graphical path right to that templates folder.
OR
*After* creating the template:
You can right click on the template icon in the "Files - New" window,
And click on "Properties".
Under the General tab, you'll see the path to the location.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"greg" <iuouh@ghfhg.com> wrote in message
news:utZgr4sgIHA.5280@TK2MSFTNGP02.phx.gbl...
> thanks, I will take a look.
>
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
> news:eW8fm2sgIHA.536@TK2MSFTNGP06.phx.gbl...
>> Hi Greg
>>
>> See this page for a sheet template example
>>
http://www.rondebruin.nl/sheettemplate.htm
>>
>> If you want to install it you can use this in your code
>>
>> Application.TemplatesPath
>>
>>
>>
>> --
>>
>> Regards Ron de Bruin
>>
http://www.rondebruin.nl/tips.htm
>>
>>
>> "greg" <iuouh@ghfhg.com> wrote in message
>> news:ebdKnosgIHA.6032@TK2MSFTNGP03.phx.gbl...
>>> thanks,
>>> I see that that works.
>>>
>>> However if you want to install using an installer. how do you know
>>> where to put it?
>>> is there a reg key that gives the location?
>>>
>>> thanks
>>>
>>>
>>> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
>>> news:uz4mLSsgIHA.1944@TK2MSFTNGP02.phx.gbl...
>>>> Some different computers and versions have slightly different
>>>> locations.
>>>>
>>>> Let XL automatically place it in the proper location for you by simply
>>>> clicking:
>>>>
>>>> <File> <Save As>
>>>> And, at the bottom of the window, expand the "Save As Type" box,
>>>> and click on
>>>> "Template (*.xlt)"
>>>>
>>>> Then <Save>
>>>>
>>>> And it should be able to be opened in the "Files - New" window.
>>>>
>>>> To modify the template, do the same thing to an opened copy, just
>>>> remove the
>>>> suffix ID numeral before saving.
>>>> --
>>>>
>>>> HTH,
>>>>
>>>> RD
>>>> =====================================================
>>>> Please keep all correspondence within the Group, so all may benefit!
>>>> =====================================================
>>>>
>>>>
>>>> "greg" <iuouh@ghfhg.com> wrote in message
>>>> news:%233fCl9rgIHA.2540@TK2MSFTNGP05.phx.gbl...
>>>> I am having problems trying to create an excel template.
>>>> I took a xlt file. and put it in the dir
>>>> C:\Program Files\Microsoft Office\Templates\1033
>>>> However I do not see it ever showing up in the
>>>> file>new>on my computer
>>>>
>>>> is there something special you have to do?
>>>> thanks
>>>>
>>>>
>>>>
>>>
>