From: Deepa Rajendran <deeparaj12@...>
Date: 2009-02-24T21:00:49+09:00
Subject: Fetch an excel sheet name  in ruby

hi,
   I got this error.in `method_missing': Open (WIN32OLERuntimeError)
    OLE error code:800A03EC in Microsoft Office Excel

For the below coding:

require 'win32ole'
require 'rubygems'

xl = WIN32OLE.new('Excel.Application')
wb = xl.Workbooks.Open("C:\Documents and
Settings\mpf18.MPFD18\Desktop\Achievement-with Target(JNJ-Wise)")
ws = wb.Worksheets(1)
puts ws.Name
wb.Close
xl.Quit
-- 
Posted via http://www.ruby-forum.com/.