Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2000 vs. 2003
Is there a good resource that reviews any basic differences between Excel
VBA programming in 2000 vs. 2003? It'd appear that there are some diifferences that cause some work I've done in 2003 (1/3 recorded, 1/3 recorded & edited, 1/3 straight entry) to bomb when run in 2000. In the example below, 2003 records the last 3 DataOption arguments. Removed (the feature's not in 2000 and doesn't get recorded), the sub runs fine: Range("A11:K65").Sort Key1:=Range("A12"), Order1:=xlAscending, Key2:= _ Range("B12"), Order2:=xlAscending, Key3:=Range("G12"), Order3:= _ xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:= _ xlSortNormal, DataOption3:=xlSortNormal I figureed this one out myself & have since read where others have asked about this. Are there other land mines out there? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2000 vs. 2003
You're right: DataOption1, DataOption2, and DataOption3 were added in xl2002.
I don't know of any definitive resource--xl2002 does have a "what's new" in it's help--and so does xl2003. If you have to support various versions of excel, it's usually much better to develop in the oldest version of excel. Bill G wrote: Is there a good resource that reviews any basic differences between Excel VBA programming in 2000 vs. 2003? It'd appear that there are some diifferences that cause some work I've done in 2003 (1/3 recorded, 1/3 recorded & edited, 1/3 straight entry) to bomb when run in 2000. In the example below, 2003 records the last 3 DataOption arguments. Removed (the feature's not in 2000 and doesn't get recorded), the sub runs fine: Range("A11:K65").Sort Key1:=Range("A12"), Order1:=xlAscending, Key2:= _ Range("B12"), Order2:=xlAscending, Key3:=Range("G12"), Order3:= _ xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:= _ xlSortNormal, DataOption3:=xlSortNormal I figureed this one out myself & have since read where others have asked about this. Are there other land mines out there? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie chart built in 2000, now in 2003 but unable to edit 2003-way | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
excel 2000 and 2003 | Excel Discussion (Misc queries) | |||
MS Excel 2000 & VS .NET 2003 | Excel Programming | |||
Excel 2000 and 2003 | Excel Programming |