Sort Macro not working in 2003 (but ok in 2007)

**mania112** · 08-12-2009, 06:05 AM

Can anyone explain why this macro is working fine in 2007 and not in excel 2003:

Please Login or Register  to view this content.

thanks

**Andy Pope** · 08-12-2009, 06:17 AM

xl2003 does not know about sortfields.

the constant xlSortOnValues does not exists in xl2003

If you want to use code in both versions then develop in xl2003 not xl2007.

**mania112** · 08-12-2009, 07:32 AM

yeah that's a shame. i guess its time to upgrade some of our software

**jseufert** · 08-12-2009, 03:37 PM

Had the same issue last week. Had my client upgrade to 2007 and now it works perfectly.

**Andy Pope** · 08-13-2009, 05:10 AM

forcing an upgrade just for a bit of vba sort syntax seems a bit extreme.
I assume there where other factors in doing the upgrade.

**mania112** · 08-13-2009, 05:23 AM

well it was something in the pipeline for while, we wanted all users to have a uniform office for other reasons, inlcuding Outlook.

Sort Macro not working in 2003 (but ok in 2007)

LinkBack

Thread Tools

Rate This Thread

Display

Sort Macro not working in 2003 (but ok in 2007)

Re: Sort Macro not working in 2003 (but ok in 2007)

Re: Sort Macro not working in 2003 (but ok in 2007)

Re: Sort Macro not working in 2003 (but ok in 2007)

Re: Sort Macro not working in 2003 (but ok in 2007)

Re: Sort Macro not working in 2003 (but ok in 2007)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions