?
Solved

Template ending in xlsm and xltm. What's the difference? and Where is it?

Posted on 2011-03-04
3
Medium Priority
?
5,675 Views
Last Modified: 2012-05-11
I have a macro that I created that I saved as a template.  When I look for it in the Program Explorer, I can't find it unless I use the search tool.  It tells me it is saved in the C:|Documents and Settings\Jane Doe\Application Data\Microsoft\Templates folder.  Then I can click on it and it will run.  Why can't I locate it in my Program Explorer?  Also, what's the difference between the xslm and xltm copies?  Which is the executable?

Since I am asking 2 questions, I am increasing the Points value and am willing to split it.
0
Comment
Question by:chaverly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
McOz earned 1000 total points
ID: 35036718
These are both macro-enabled workbooks. The difference is that the "xltm" file is a template, so opening it will create a *new* workbook based on that file. If you open the "xlsm" it will simply open the file.

-Oz
0
 

Author Comment

by:chaverly
ID: 35037086
That tells me a lot.  Thank you.  I will split the points with you.  Now if I could just find it.  Where is it in my Program Explorer?
0
 

Author Comment

by:chaverly
ID: 35037137
I found what was wrong.  My folder properties were set wrong.  
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question