I have some old VB6 / Excel code that appears to have quit working recently. I use an Excel add-in to call my VB6 component and pass the Workbook object. My VB6 project is referencing the Microsoft Excel 11.0 Object Library. Here's the public interface declaration in VB6 that my addin is calling:

Please Login or Register  to view this content.
The return code is just an enum. The important part is that ovWorkbook is early bound and declared As Excel.Workbook.

If I inspect 
Please Login or Register  to view this content.
I get back the empty string! If I inspect 
Please Login or Register  to view this content.
I get "Sheet1" as expected.

Does anyone know why this appears to have quit working? I know that the code used to work and it still does if I use it in the Excel VBE. I have confirmed that it is now broken in Excel 2000 and Excel 2003. I don't know of any environments where it currently works. Any information would be greatly appreciated.

Thanks,
Ian