From: Li Chen <chen_li3@...>
Date: 2006-12-04T05:54:50+09:00
Subject: Re: VBA to Ruby code translate



>     ActiveChart.SeriesCollection(1).Select
>     ActiveChart.SeriesCollection(1).ErrorBar
>        Direction:=xlY, Include:=xlBoth, _
>         Type:=xlCustom, Amount:="=Sheet1!R5C2:R5C6",
>          MinusValues:= _
>         "=Sheet1!R5C2:R5C6"

Hi all,

I just figure out how to translate the above VBA code into Ruby code:
changes some of them into a hash in Ruby

...
activeChart.SeriesCollection(1).Select
activeChart.SeriesCollection(1).ErrorBar(
  'Direction' => ExcelConst::XlY,
  'Include'=>ExcelConst::XlBoth,
  'Type'=>ExcelConst::XlCustom,
  'Amount'=>"=Sheet1!R5C2:R5C6",
  'MinusValues'=>"=Sheet1!R5C2:R5C6"
)

-- 
Posted via http://www.ruby-forum.com/.