On Nov 14, 3:02 pm, Jano Svitok <jan.svi... / gmail.com> wrote:
> On Nov 14, 2007 1:10 PM, zxem <david.z... / gmail.com> wrote:
>
> > All,
>
> > I am using Ruby 1.8.6 now and trying to so a pass by reference COM
> > call through win32ole.
>
> > The code looks like this: (I am not really calling Excel)
>
> > ------------------------------------------------------
> > excel = WIN32OLE.new("excel")
> > excel.getCell(cell, column, row)
> > ---------------------------------------------------
>
> > The first parameter I need to pass into getCell on line2 is a complex
> > object(not String/double).
> > Could anyone please teach me how to do this call in Ruby?
>
> Look at 1.9 WIN32OLE documentation. The last paragraph discusses the
> returning by reference (in short, you'll find the result in
> WIN32OLE::ARGV).
>
> There are some interesting threads about this in the archive. Look for
> Masaki Suketa's posts (he is the author/maintainer).
> One of them is this:http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/232146
>
> Jano

Hi,

I went through all the existing threads before I posted this one
because I did not fully understand them. Could anyone give me some
more detailed examples.

Cheers!