Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default using xltm as template

Hello,
This is not really a programming question, although I'm sure someone in this forum can help. I write a lot of excel programs/macros in templates. When I save the templates as xlt everything works fine. When I go to create a new file from template, my templates (with the xlt) extension show up in the My Templates location. But if I save the template as xltm the templates do not show up. They are in the proper folder C:\Users\Administrator\AppData\Roaming\Microsoft\E xcel. But they don't show up when I try to create a new excel file from template.

Can someone explain how to fix this?

thanks,
Andy
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default using xltm as template

Andrew wrote :
Hello,
This is not really a programming question, although I'm sure someone in this
forum can help. I write a lot of excel programs/macros in templates. When I
save the templates as xlt everything works fine. When I go to create a new
file from template, my templates (with the xlt) extension show up in the My
Templates location. But if I save the template as xltm the templates do not
show up. They are in the proper folder
C:\Users\Administrator\AppData\Roaming\Microsoft\E xcel. But they don't show
up when I try to create a new excel file from template.

Can someone explain how to fix this?

thanks,
Andy


You can save anywhere you like, not needing to use Excel's *suggested*
location. Move your xltm to the Templates folder! Next time, just
navigate to that location in the SaveAs dialog.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default using xltm as template

El domingo, 15 de julio de 2012 10:16:56 UTC-6, GS escribió:
Andrew wrote :
> Hello,
> This is not really a programming question, although I'm sure someone in this
> forum can help. I write a lot of excel programs/macros in templates.. When I
> save the templates as xlt everything works fine. When I go to create a new
> file from template, my templates (with the xlt) extension show up in the My
> Templates location. But if I save the template as xltm the templates do not
> show up. They are in the proper folder
> C:\Users\Administrator\AppData\Roaming\Microsoft\E xcel. But they don't show
> up when I try to create a new excel file from template.
>
> Can someone explain how to fix this?
>
> thanks,
> Andy

You can save anywhere you like, not needing to use Excel's *suggested*
location. Move your xltm to the Templates folder! Next time, just
navigate to that location in the SaveAs dialog.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Garry,
Thanks, but I don't understand. I thought I was saving to the template folder. When I select FileNewMy Templates, excel navigates to the default template folder. I would much prefer not to use the default folder because there is so much chaff to sift through. If I made a new template folder, how would I get excel to navigate to it?

Andy
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a .XLTM template file default to save as .XLSM type? NZCoyote Excel Discussion (Misc queries) 1 April 8th 10 06:01 AM
xltm saveas xlsm Helmut Excel Programming 6 March 3rd 10 12:22 PM
SaveAs xltm programmatically JNW Excel Programming 1 July 29th 08 04:11 PM
Corrupt .xltm Eric Excel Discussion (Misc queries) 5 May 23rd 07 11:39 PM
Excel template to load automatically as the default template? David Excel Discussion (Misc queries) 1 March 21st 05 01:24 PM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"