From: "Victor \"Zverok\" Shepelev" <vshepelev@...>
Date: 2007-03-23T22:42:36+09:00
Subject: Re: Sorting Excel table with OLE

From: list-bounce@example.com [mailto:list-bounce@example.com] On Behalf Of
Damjan Rems
Sent: Friday, March 23, 2007 3:34 PM
>
>David Mullet wrote:
>> On Mar 23, 3:13 am, Damjan Rems <d_r...@yahoo.com> wrote:
>>> Posted viahttp://www.ruby-forum.com/.
>> xlAscending = 1
>> xlDescending = 2
>> excel.Range("a2:e5000").Sort(excel.Range("b2"), xlAscending)
>>
>
>Thank you very much.
>
>I was looking for references on net (first 5 pages on google), but
>couldn't find anything solid. Do you know any good reference site
>(beside your blog pages ofcourse).
>

For this (and similar) cases, the best "reference" would be: writing macro
in Excel, read its VBA code and translate it to Ruby (the translation is
pretty straightforward).

V.