Software

Ask something
Discussion Locked

Macros Excel 97 versus Excel XP

0 helpful
5 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The lines listed below are in a macro in Excel XP. It runs fine there, but will not run in 97.
Selection.Sort Key1:=Range("A8"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Why would it run in one but not the other?

5 replies

by dklippert

Excel 97 used VBA5, and Excel 2000 and XP use VBA6. There are only slight diferences.
I would start be eliminating:

DataOption1:xlSortNormal

That is the default sort. If needed, try:

OrderCustom:=1

by carquiza

Hi,

All I can say is programs are to be made to run on different platforms but maybe this design runs only on a particular version that he supposedly supported. If you try to see it each versions of VB is different as it says why those programswon't run it is also VB program the language is already been slightly change. This how programmers works so that they can easily remedy the problem. Hope this gives you an insight.

Why need EXCEL 97, MS EXCEL 2000, EXCEL XP?
Which is change....nothing? 97, 2000, XP
Worth to upgrade if it satisfy you and you gain
what you are expecting. . . .

Cheers,

Mel Arquiza
Home Page Design
http://hpd.welcome.to

This discussion is closed to new replies.