From: David Mullet <david.mullet@...>
Date: 2009-02-24T22:24:37+09:00
Subject: Re: Fetch an excel sheet name  in ruby

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

Escape (double-up) your backslashes in double quotes, or place your 
filepath in single quotes.

Change this:

wb = xl.Workbooks.Open("C:\Documents and 
Settings\mpf18.MPFD18\Desktop\Achievement-with Target(JNJ-Wise)")

To this:

wb = xl.Workbooks.Open("C:\\Documents and 
Settings\\mpf18.MPFD18\\Desktop\\Achievement-with Target(JNJ-Wise)")

Or this:

wb = xl.Workbooks.Open('C:\Documents and 
Settings\mpf18.MPFD18\Desktop\Achievement-with Target(JNJ-Wise)')

David

http://rubyonwindows.blogspot.com/
http://rubyonwindows.blogspot.com/search/label/excel
-- 
Posted via http://www.ruby-forum.com/.