2003 to 2007 VBA ActiveX

[wmstrand]

I developed VBA macros in Excel 2007 that do not work in Excel 2003 - the Office CompatibilityPack is installed and the workbook is saved as .xls - I am using ActiveX CommandButtons - the "active.workbook." line of code is highlighted as in error, and will not compile - any thoughts would be appreciated . . .


ActiveWorkbook.Worksheets ("May 2010").Sort.SortFields.Clear

 

[Smitty]

Welcome to the Board!

You'll need to post the code.

 

[ZVI]

SortField objects were added to Excel 2007.
It doesn't work in previous versions of Excel.
Sort ranges instead

 

[Smitty]

SortField objects were added to Excel 2007.

Duh - Didn't see this:

ActiveWorkbook.Worksheets ("May 2010").Sort.SortFields.Clear