Excel 2007 Can't Save File with VB Script but it can in 97/2003format???

[f252863]

"This workbook contains one of more of the following features that are
not supported by the selected file format:
- Script Objects"

If I save as a regular Excel 2007 file it is macro free (why?). If I
save as an Excel macro enabled workbook I get the message above. If I
save as the old 97/2003 format it can run macros and scripts.

Anyone know why the newer version can't support macros and scripts?

Thanks!

 

[FSt1]

hi
not sure but are you saving your file as .xlsx format. if so you need to
save it as a .xlxm format.
see this site
http://www.fileinfo.net/extension/xlsm

regards
FSt1

 

[f252863]

Thanks,

I'm saving as 4.xlsm, I'll try xlsx. I did check one of my scripts
and it still works so I don't know what it means by script objects.