From: Li Chen Date: 2006-12-02T02:25:18+09:00 Subject: Re: VBA to Ruby code again >> line 65 is >> >> chart1.SeriesCollection(1).ErrorBar Direction=ExcelConst::XlY > > This is aonther type of error. I suppose you should do: > > chart1.SeriesCollection(1).ErrorBar 'Direction' => ExcelConst::XlY > > but it's a tip from documentation. See the programming ruby for how to > transform XXX=YYY from VB to Ruby. What is the page in 2nd edition? I read through the automation with excel part but I don't remember the part talking about VB to Ruby. > > What I'm sure about is that Direction=ExcelConst::XlY is an assignment > and as such it can't work. Your line is equal to the following: > > Direction=ExcelConst::XlY > chart1.SeriesCollection(1).ErrorBar(ExcelConst::XlY) Either of them doesn't work and Ruby still complains it. Li -- Posted via http://www.ruby-forum.com/.