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


F

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

Advertisements

Ad

Advertisements

F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top