Excel 2010 xlsm file errors in Excel 2007

[music_al]

Is there a way of ensuring a Excel 2010 Macro Enabled file works fine in Excel 2007 ?

 

[music_al]

Its because one of the users is using 2007 and the errors when it gets to this line with Subscript out of range...

    Windows("KPI Generator.xlsm").Activate

 

[Fluff]

There's nothing wrong with that lie & it will work quite happily in Xl2007.
The error probably occurs because the workbook isn't open.

 

[steve the fish]

That will error regardless of version if there is no workbook called that open.

 

[music_al]

No, it is definitely open - I'm looking at it on the screen right now.

 

[steve the fish]

Has it been saved and also saved as an xlsm?

 

[Fluff]

Also change Windows to Workbooks