Excel cannot open the file "filename.xlsm" because the file format or file extension is not valid?

Question

In Excel 2007, I get this error when I try to run a script a friend posted to the web. I have heard of no one else having trouble.

Any ideas what might be going on here?

Solution

Check your folder options for the .xlsm extension. That's used by Excel 2007 to indicate a macro-enabled workbook. If you have an earlier version of Office (or none at all), it may not be set. You may need to install the compatibility pack, re-install or repair Office 2007, or change the folder options.

Comments

[Ƭᴇcʜιᴇ007]

Sounds like there's probably something incorrect with that specific script in your specific environment...

[user72923]

Very specific...