Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!

  #2   Report Post  
Posted to microsoft.public.excel.misc
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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i save a excel 2007 file as .dbf katherine Excel Discussion (Misc queries) 2 March 20th 08 03:28 PM
can't save VBA script when saving excel file thinktwice Excel Discussion (Misc queries) 5 December 27th 06 07:38 AM
Save Excel File every wednesday VB Script Help !! sam76210 Excel Discussion (Misc queries) 0 March 8th 06 04:05 PM
Script to save Excel file to the server. raj41977 Excel Discussion (Misc queries) 3 December 8th 05 02:48 PM
when i save xls file, debug script is running and canno't save fil Imtiaz Excel Discussion (Misc queries) 1 July 16th 05 03:47 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"