View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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!