Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |