From: Kent Dahl <kentda+news@...>
Date: 2004-04-15T00:04:12+09:00
Subject: Re: Sort Excel spreadsheet with Ruby?

Moran, Craig M (BAH) wrote:
> Has anyone successfully used Ruby to sort an Excel spreadsheet?  It has been
> said that VBScript usually translates directly to Ruby if you're using
> WIN32OLE.  For the most part, I have found this to be true.  However, this
> example translated from VBScript fails on the Sort line:
[...]
> sheet.Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlNo,
> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Is Sort expecting a Hash argument?

In that case, you would probably be more successful using => instead of 
:= for all the arguments in that line.

Never used WIN32OLE, so YMMV and HTH :)

-- 
(\[ Kent Dahl ]/)_    _~_    _____[ http://www.pvv.org/~kentda/ ]_____/~
  ))\_student_/((  \__d L b__/     Master of Science in Technology     )
( \__\_�|�_/__/ ) _)  Industrial economics and technology management (
  \____/_�_\____/ (____engineering.discipline_=_Computer::Technology___)