From: Li Chen <chen_li3@...>
Date: 2006-12-04T13:35:12+09:00
Subject: Why this script doesn't work?


Hi all,

I copy a script from WIN32OLE documentation and run it. I find that Ruby
complains it at line    cells = sheets.cells("A1:A5").

Do I miss something?

Thanks,

Li

##
require 'win32ole'

  excel = WIN32OLE.new('Excel.Application')
  excel.Visible="True"

   book = excel.workbooks.add
   sheets = book.worksheets(1)

   cells = sheets.cells("A1:A5")

   cells.each do |row|
     row.value = 10
   end

##output
>ruby test3.rb
test3.rb:13:in `method_missing': cells (WIN32OLERuntimeError)
    OLE error code:80020005 in <Unknown>
      <No Description>
    HRESULT error code:0x80020009
      Exception occurred.  from test3.rb:13
>Exit code: 1

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