From: Masaki Suketa <masaki.suketa@...>
Date: 2007-09-30T17:48:16+09:00
Subject: Re: OLE Object - combo box problem

Hello,
Bulhac Mihai wrote:
 > previous error was resolved, but i still get one:
 >
 > excel2.rb:207:in `method_missing': Item (WIN32OLERuntimeError)
 >     OLE error code:800A000D in VBAProject
 >       Type mismatch
 >     HRESULT error code:0x80020009
 >       Exception occurred.  from excel2.rb:207:in `excel_asitt_menu'
 >
 > 207 line is :
 > modu=$asitt_workbook.VBProject.VBComponents.Item($worksheet_asitt_menu)

Is $worksheet_asitt_menu WIN32OLE object?
If so, try
   Item($worksheet_asitt_menu.name)

Item's argument must be Worksheet name string(ie. String object)
not WIN32OLE object.

   Regards,
   Masaki Suketa