View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] f252863@hotmail.com is offline
external usenet poster
 
Posts: 19
Default 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!