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

"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!

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

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

" wrote:

"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!

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

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.