Saving a xls as a xlt

  • Thread starter Thread starter ole_
  • Start date Start date
O

ole_

Hi,

i am trying to save a xls file as a xlt file, but when i save it on a
network share or "C:\" it don't
function as a XLT file (you can "save" it, it dosn't popup as " save as"),
but if i save it
in the propper place (c:\documents and s...\ole\application
data\microsoft\template)
it works, is there a way to save it as C:\mytemplate.xlt where it will
function as a xlt file.

AHA.
Ole
 
Hi
Not sure but it may just be that you do not select the correct file type
when you try Save As?

HTH
Cordially
Pascal
 
If you are using Microsoft Windows 95 or later, or Microsoft Windows NT
version 4.0 or later, you can make a custom template available to others by
storing the template on a network location. For example, you might want all
users in your workgroup to use a custom template for a special project
without having to place individual copies of the template on each desktop.
Instead, place the template in a folder in a network location that is
accessible by all users in your group. Then create a shortcut to the folder
or template, and have users place the shortcut in their Templates folder.



From the Help file..

Mike F
 
Nope, i have tried ten times on differtent paths and the only thing that
works is c:\documents and s...\ole\application data\microsoft\template.

It dont nessesary need to be a XLT file but the user may not have the "save"
option, thats why i would like it to be a XLT file

AHA
Ole
 
papou asked if you really saved the file as a template.

At the bottom of the File|SaveAs dialog, there's a: "Save As Type" box

Did you select "Template (*.xlt)" in that dropdown.

(Change this first, then change the location to your network folder.)

===

If you did this, then when the users open this template, do they get the
template itself (with a name of mytemplate.xlt in the title bar) or do they get
a new workbook based on that template (with a name of mytemplate1 (no extension)
in the title bar)?

Are the users doing File|New to create the new workbook?

===
An alternative. Save your file as mytemplate.xls (just a regular workbook), but
then use windows explorer to mark that file as ReadOnly. It isn't foolproof,
but it's usually sufficient.
 
Dave Peterson said:
papou asked if you really saved the file as a template.
Click to expand...

Yes i did
At the bottom of the File|SaveAs dialog, there's a: "Save As Type" box

Did you select "Template (*.xlt)" in that dropdown.
YES

(Change this first, then change the location to your network folder.)

===

If you did this, then when the users open this template, do they get the
template itself (with a name of mytemplate.xlt in the title bar) or do they get
a new workbook based on that template (with a name of mytemplate1 (no
Click to expand...
extension)

They get a new workbook based on the template call mytemplate1
Are the users doing File|New to create the new workbook?
YES

An alternative. Save your file as mytemplate.xls (just a regular workbook), but
then use windows explorer to mark that file as ReadOnly. It isn't foolproof,
but it's usually sufficient.
Click to expand...

Yes, and then i now have made this as a backup :-)

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

If SaveAsUI = False Then
MsgBox "Husk og brug 'Gem Som' når du gemmer denne fil", vbCritical

Cancel = True
End If

And that is okay for me.

Thanks for your help
Ole
 
Hi mike,

I can't see how that should help me, if i have to make a shourtcut to all
users
or copy the file it self to all users it's pretty much the same (and to much
work:-)

Thanks
Ole
 
Back
Top