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

Hi Ken

See this page about the file formats
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ken Ellis" schreef in bericht news:fsidneCoH_KbBWXanZ2dnUVZ8qeknZ2d@plusnet...
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