Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code worked in Excel 2003 but when I run it in Excel 2007 I
get the following message: "The following features cannot be saved in macro free workbooks .VB" Set wbResults = Workbooks.Add(Template:=stResultsTemplateFileParam ) wbResults.Sheets(1).Name = "Test Results" wbResults.SaveAs Filename:=stResultsFileFullname The template file has a macro and is defined as an .xlsm file. I tried adding '.xlsm' to stResultsTemplateFileParam but no good. I cannot see any property for wbResults that I could set to specify the workbook as .xlsm. Thanks for any help. Ken Ellis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 to 2003 conversion | Excel Discussion (Misc queries) | |||
conversion from 2003 to 2007 | Excel Worksheet Functions | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
How do I prevent 2007 to 2003 Conversion? | Excel Discussion (Misc queries) | |||
Unable to save workbook within WorkbookBeforeClose | Excel Programming |