View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
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