Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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 "ole_" a écrit dans le message de ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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 "ole_" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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" skrev i en meddelelse ... 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 "ole_" a écrit dans le message de ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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. ole_ wrote: 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" skrev i en meddelelse ... 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 "ole_" a écrit dans le message de ... 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
"Dave Peterson" skrev i en meddelelse ... papou asked if you really saved the file as a template. 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 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. 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, 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a xls as a xlt
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 "Mike Fogleman" skrev i en meddelelse ... 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 "ole_" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving as XML | Excel Discussion (Misc queries) | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
saving as an add-in? | Excel Worksheet Functions | |||
Saving help | Excel Discussion (Misc queries) | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |