Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
I have created macros in 2003. They won't work in 2000. Is there a way to
save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
You need to develope the macros using the lowest common denominator version
(in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
Jim,
The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
Post the code for the parts that don't work (or all of it if it's not too
long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
Below are the 2 macros that will work in 2003 but not in 2000.
Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter ' ' End Sub "Nick Hodge" wrote: Post the code for the parts that don't work (or all of it if it's not too long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
I've not got XL2000 so I've stripped this back as much as I can, but it
should still be fine. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Below are the 2 macros that will work in 2003 but not in 2000. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter ' ' End Sub "Nick Hodge" wrote: Post the code for the parts that don't work (or all of it if it's not too long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
I tried this code. It doesn't work in 2000 or 2003. Any other suggestions?
"Nick Hodge" wrote: I've not got XL2000 so I've stripped this back as much as I can, but it should still be fine. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Below are the 2 macros that will work in 2003 but not in 2000. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter ' ' End Sub "Nick Hodge" wrote: Post the code for the parts that don't work (or all of it if it's not too long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
What doesn't work? where does it error? Why not record it in XL2000, it'll
be sure to work then? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... I tried this code. It doesn't work in 2000 or 2003. Any other suggestions? "Nick Hodge" wrote: I've not got XL2000 so I've stripped this back as much as I can, but it should still be fine. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Below are the 2 macros that will work in 2003 but not in 2000. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter ' ' End Sub "Nick Hodge" wrote: Post the code for the parts that don't work (or all of it if it's not too long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros created in 2003 won't work in 2000
I finally figured it out. Tanks forthe help.
"Nick Hodge" wrote: What doesn't work? where does it error? Why not record it in XL2000, it'll be sure to work then? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... I tried this code. It doesn't work in 2000 or 2003. Any other suggestions? "Nick Hodge" wrote: I've not got XL2000 so I've stripped this back as much as I can, but it should still be fine. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess Selection.AutoFilter End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Below are the 2 macros that will work in 2003 but not in 2000. Sub princolors() ' ' princolors Macro ' Macro recorded 5/19/2006 by Doug Range("A1647:E1747").Select Selection.AutoFilter Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=2, Criteria1:="<" Range("A1646").Select Range("A1646:E1747").Select Selection.PrintOut Copies:=1, Collate:=True Range("A1646").Select Selection.AutoFilter ' End Sub Sub sortcolorscode() ' ' sortcolorscode Macro ' Macro recorded 4/25/2006 by Doug Selection.AutoFilter Range("A1647:E1747").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter ' ' End Sub "Nick Hodge" wrote: Post the code for the parts that don't work (or all of it if it's not too long) and we can fix them all at once -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "dford" wrote in message ... Jim, The one problem is in the sort routine as you described. I think I know how to delete that as you suggest. The other problem is with a print routine using a macro. How do I correct that. When I fix these to work in 2000, will they still work in 2003? "Jim Thomlinson" wrote: You need to develope the macros using the lowest common denominator version (in your case 2000). As a guess your problem will reside in your sort routines. There in a new argument in the Sort which you can just remove DataOption1:=xlSortNormal <-Delete this... -- HTH... Jim Thomlinson "dford" wrote: I have created macros in 2003. They won't work in 2000. Is there a way to save in an earlier version and make it work. I tried to save it in 97-2000 version and it still does not work. Is there a way to solve this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Macros shortcuts not working from 2003 to 2000 | Excel Worksheet Functions | |||
where did my old 2000 Excel macros go when I upgraded to 2003? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |