anything in Excel...

It's Excel-o-lozy...

Trick - Macro enabled Excel 2003 file not working in Excel 2007

Basic funda of Macro files:
Excel 2003 is saved as ".xls" whereas
Excel 2007 is saved as ".xlsm" which means Macro enabled...

Sometimes except all things set in Excel 2007, Macro enabled ".xls" file of 2003 doesnt work.

Simple trick is:
Open Excel 2007
Open your old versioned file
Save it as ".xlsm"
Close Excel
Re-open it in Excel 2007
wonders......don't tell me...

Now don't ask me how to set Excel 2007 to work with Macro enabled files.

0 comments: