How to convert macros in Excel

[pva]

Hello,

I have an Excel 2010 spreadsheet with some macros. Many users in our organization are still using Excel 2003, so I'm saving this spreadsheet in the older version, xls.

However, the macros created in Excel 2010 don't work in Excel 2003. This is just one example - the execution breaks here:

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

with the message:

Object doesn't support this property or method (Error 438)

Is there a way to convert Excel 2010 macros to 2003 version?

Thank you.

[OnErrorGoto0]

There is no conversion tool that I am aware of. Generally you are better off creating the code in the oldest version you have to support. Here the specific issue is that the Sort object did not exist pre-2007 so you have to use the Range.Sort method instead.

[pva]

Thank you.

How would I use Range.Sort to apply it to the whole worksheet? I'm not an expert in VBA.

[OnErrorGoto0]

What are you sorting on? Roughly speaking it would be:

Please Login or Register  to view this content.

for example

[Mordred]

The following could be used (I think) in a 2010 workbook, 2007 workbook, and a 2003 workbook but you'll need to find the code for sorting accordingly to the version.

Please Login or Register  to view this content.

[pva]

Sorry, I've just signed up.

Please Login or Register  to view this content.

[OnErrorGoto0]

I think that is simply:

Please Login or Register  to view this content.

[pva]

Thank you, this seems to work.

[OnErrorGoto0]

Glad to help. Please don't forget to mark the thread Solved (see FAQ link at top of page for instructions).