From: Saumya Negi <saumya_negi@...>
Date: 2010-06-04T07:21:39+09:00
Subject: Re: find whole words in excel

Though it's too late for the reply, It could help others in future:
With reference to http://rubyonwindows.blogspot.com/search/label/excel 
->
Loading the Win32OLE Constants section, I could work this out as 
follows:

class XLConst
end

WIN32OLE.const_load(excel, XLConst)
rFoundCell = wsheet.Range("A1:IV1").Find('OrgId', 
'LookAt'=>XLConst::XlWhole)

Hope this helps, Cheers!
-- 
Posted via http://www.ruby-forum.com/.