none
License information for this component not found - Excel 2010

    Question

  • Hi,

    I am migrating some Excel VBA macro from Excel 2007 to Excel 2010, but when I try to run it I get the following error:

    "License information for this component not found. You do not have an appropriate license to use this functionality in the design environment"

    I debugged it and it turned out that the issue is in the creation of an object from a Java class:

    Sub testvbi()
    Dim vbi As Object
    Set vbi = JavaNew("TestClass")
    End Sub

    I have of course also added the j2ee-cas-com-bridge in order to be able to use JavaNew.

    Note that this works fine in Excel 2007 and I get the same error also if I run:

    Set vbi = CreateObject("TestClass")

    So maybe the license problem is not related to the com-bridge, but maybe to Excel itself?

     

    DSilve

    Friday, June 24, 2011 8:52 AM

Answers

All replies