 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008how to create an excel template
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 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.  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== 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 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 > Some different computers and versions have slightly different locations. > [quoted text clipped - 21 lines] > is there something special you have to do? > thanks 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 SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > thanks, > I see that that works. [quoted text clipped - 30 lines] >> is there something special you have to do? >> thanks thanks, I will take a look. > Hi Greg > [quoted text clipped - 39 lines] >>> is there something special you have to do? >>> thanks 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. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > thanks, I will take a look. > [quoted text clipped - 42 lines] >>>> is there something special you have to do? >>>> thanks Just a note to add. If you want to change the default Templates folder, open Word.........yes, I write Word......... and make the change at Tools>Options>File Locations. Gord Dibben MS Excel MVP >There are a couple of relatively simple ways to get that info. > [quoted text clipped - 10 lines] >And click on "Properties". >Under the General tab, you'll see the path to the location.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.