WIN32OLE.ole_show_help problem

ruby-talk
1

Hi,

ruby 1.8.6 (2009-03-31 patchlevel 368) [i386-mswin32_90]
Vista Home Premium
Excel 2007

Here's the documentation for WIN32OLE.ole_show_help in win32ole.c:

/*
* call-seq:
* WIN32OLE.ole_show_help(obj [,helpcontext])

···

*
* Displays helpfile. The 1st argument specifies WIN32OLE_TYPE
* object or WIN32OLE_METHOD object or helpfile.
*
* excel = WIN32OLE.new('Excel.Application')
* typeobj = excel.ole_type
* WIN32OLE.ole_show_help(typeobj)
*/

When I tried to run that sample I got:

irb(main):005:0> excel = WIN32OLE.new('Excel.Application')
=> #<WIN32OLE:0x45fdf08>
irb(main):006:0> typeobj = excel.ole_type
WIN32OLERuntimeError: unknown property or method `ole_type'
    HRESULT error code:0x80020006
      Unknown name.
        from (irb):6:in `method_missing'
        from (irb):6

Any ideas?

Regards,

Dan

2

Hello,

irb(main):005:0> excel = WIN32OLE.new('Excel.Application')
=> #<WIN32OLE:0x45fdf08>
irb(main):006:0> typeobj = excel.ole_type
WIN32OLERuntimeError: unknown property or method `ole_type'
    HRESULT error code:0x80020006
      Unknown name.
        from (irb):6:in `method_missing'
        from (irb):6

Any ideas?

Sorry, this is the bug of comment of win32ole.c.
WIN32OLE#ole_type is available in Ruby 1.9.
Instead, try
   typeobj = WIN32OLE_TYPE.new('Microsoft Excel 12.0 Object Library',
                               'Application')

   Regards,
   Masaki Suketa

···

At 08/29/2009 05:11 AM, Daniel Berger wrote: