WIN32OLE_VARIABLE#visible?
Instance Public methods
Returns true if the variable is public.
1 2 3 4 5 6 7 8 9 10 11 12 | tobj = WIN32OLE_TYPE . new ( 'Microsoft Excel 9.0 Object Library' , 'XlSheetType' ) variables = tobj.variables variables. each do |variable| puts "#{variable.name} #{variable.visible?}" end The result of above script is following: xlChart true xlDialogSheet true xlExcel4IntlMacroSheet true xlExcel4MacroSheet true xlWorksheet true |
Please login to continue.