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..