Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Templates in 2007
Hello,
I am trying to write a template (macro-enabled) for excel 2007. When I try to open it I get an error stating that the file is either corrupted or the file extension is not valid. I assume this is a bug. Does anyone know a way around this. I am saving the template as test.xltm. I have no problems during the save. It's only when I try to use the template that I get this error. thanks, Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Templates in 2007
Are you saving the file using something like this
ActiveWorkbook.SaveAs fileName:="myfile.xlst" If so, you may need to add a fileformat http://msdn.microsoft.com/en-us/library/bb241279.aspx "Andrew" wrote: Hello, I am trying to write a template (macro-enabled) for excel 2007. When I try to open it I get an error stating that the file is either corrupted or the file extension is not valid. I assume this is a bug. Does anyone know a way around this. I am saving the template as test.xltm. I have no problems during the save. It's only when I try to use the template that I get this error. thanks, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Templates in Excel 2007 | Excel Discussion (Misc queries) | |||
Templates in Excel 2007 | Excel Discussion (Misc queries) | |||
Workgroup templates in Excel 2007 | Setting up and Configuration of Excel | |||
In Excel 2007,Where is the Dialog box,the templates,with???? | Excel Discussion (Misc queries) | |||
accounting templates in MS excel 2007 | Excel Discussion (Misc queries) |