Excel 2003 Com automation Auto Sorting PROBLEMS - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Advanced Scripting » Excel 2003 Com automation Auto Sorting PROBLEMS

Page 1 of 1

1

Topic Options

#174744 - 2007-03-18 09:47 PM Excel 2003 Com automation Auto Sorting PROBLEMS
99osou 99osou Fresh Scripter Registered: 2007-03-15 Posts: 6	To anyone, I have tried lots of ways, obviously none of them right, to sort an excel 2003 sheet via Kix comm automation. Some examples I've used: Code: $oXL.Range("F1").SortAscending $oXL.Range("A1:Q100").Sort("Range(A1)",,,,,,,,,,,,,,) $oXL.Range("A1:A100").Sort $oXL.Range("F1").SortAscending $RC = $oXL.Range("A1:Q60").Sort Key1=Range("C1"),Order1=xlDescending,Header=xlGuess,OrderCustom=1, MatchCase=False,Orientation=xlTopToBottom,DataOption1=xlSortTextAsNumbers $oXL.Range("A1:Q60").Sort ("C1","xlDescending","xlGuess","1","False","xlTopToBottom","xlSortTextAsNumbers") $oXL.Range("A1:Q60").Sort("Cells(1,1)",,,,,,,,,,,) And many more. I'm obviously missing the correct syntax or even if it's possible. I can create my sheet, populate, colorize, format and save with no issues, just cannot get sort to work in any way. If anyone has any thoughts.... Thank you..
Top

#174746 - 2007-03-19 12:57 AM Re: Excel 2003 Com automation Auto Sorting PROBLEMS [Re: 99osou]
Les Les KiX Master Registered: 2001-06-11 Posts: 12734 Loc: fortfrances.on.ca	Please do NOT cross-post. http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=174701 A mod should delete this one since the above linked one has a reply. _________________________ Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart

Hop to:

Shout Box

Who's Online

0 registered and 1636 anonymous users online.

Newest Members

Viginette, ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder
17888 Registered Users

Generated in 0.05 seconds in which 0.025 seconds were spent on a total of 13 queries. Zlib compression enabled.

click tracking