From: Vamsi Krishna <vamsikrishna.naidu@...>
Date: 2009-08-18T17:57:59+09:00
Subject: how to Get the list of MenuBars in excel using ruby

Hi,

 i'm trying to get the list of menubars in the excel using ruby
i can able to get the menubars count but unable to get the list of menu
bars.

my idea is to get the list of menubars and click on a perticular menu
bar item.

my code is:

require "win32ole"
excel=WIN32OLE.new("Excel.Application")
excel.visible=true
workbook = excel.Workbooks.Add
excel.DisplayAlerts = false
puts excel.MenuBars.ole_get_methods
puts excel.MenuBars.count(* Here i can get the count.)
excel.Quit


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