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

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

Page 1 of 1

1

Topic Options

#174701 - 2007-03-15 03:45 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

#174745 - 2007-03-18 10:27 PM Re: Excel 2003 Com automation Auto Sorting PROBLEMS [Re: 99osou]
Allen Allen KiX Supporter Registered: 2003-04-19 Posts: 4572 Loc: USA	See if this thread has something of use: http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Board=8&Number=87588 _________________________ (... better days ahead)
Top

#174749 - 2007-03-19 02:46 PM Re: Excel 2003 Com automation Auto Sorting PROBLEMS [Re: 99osou]
99osou 99osou Fresh Scripter Registered: 2007-03-15 Posts: 6	Thank you Allen I looked at those UDF's and found something that worked. Appreciate your help. Sorry for the Double post I thought I had posted in the wrong forum.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

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

Hop to:

Shout Box

Who's Online

0 registered and 1471 anonymous users online.

Newest Members

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

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

click tracking