locked
MSFlexgrid is not working in VBA RRS feed

  • Question

  •  

    I'm working on a machine with 64 BIT OS, windows XP SP2 and MS Office 2003. There's no Visual Basic Installed. I'm trying to make an application in Excel VBA and trying to use the MSFlexGrid Control in the form. But it is givimg the error message as "The control could not be created because it is not properly licensed". Please help.

     

    With Thanks & Regards,

    SUbhrajit

     

    Sunday, April 6, 2008 8:11 AM

All replies

  • Hey,

     

    This may help, not sure…..

     

    Check if MSFLXGRD.OCX is installed in the Windows system directory C:\WINDOWS\system32

     

    Best Regards

     

    Cathrine

     

    Sunday, April 6, 2008 5:02 PM
  • Hi Cathrine,

     

    Thanx for reply!!

     

          I've checked, the MSFLXGRD.OCX file is there both in the following directories:--

    C:\Windows\system32 and

    C:\WINDOWS\SysWOW64

     

         The Additional control "Microsoft FlexGrid Control, version 6.0" is pointing to the location "C:\WINDOWS\SysWOW64". So when I'm using this control in my form, this is giving an error....

     

     

    Regards,

    Subhrajit 

     

     

    Monday, April 7, 2008 10:58 AM
  • Having the OCX file in the right folder is not enough. The control needs to be properly registered. See the link below for how to do that:

    http://support.microsoft.com/kb/318597/en-us

     

    There are other posts in this forum, and others on msdn, related to this problem. Try using the forum search for flexgrid (there's a search box towards the top of the page).

    Monday, April 7, 2008 12:51 PM
  • Hi,

    If you are using VBA, you can not use the ActiveX control, since VBA is a limited functionality edition of VB.
    • Proposed as answer by Sibi Saravanan Wednesday, June 30, 2010 5:32 PM
    Tuesday, April 14, 2009 6:22 PM
  • The following registry entry makes MSFlexgrid work in VBA. Google for '72E67120-5959-11cf-91F6-C2863C385E30'

    REGEDIT4

    [HKEY_CLASSES_ROOT\Licenses\72E67120-5959-11cf-91F6-C2863C385E30]
    @="ibcbbbebqbdbciebmcobmbhifcmciibblgmf"

     

    If you are distributing your application using VB6 packaging tool you can add the entry via setup. It is a one time installation step. Very convenient to end users.

    e.g

    1. Add an entry like this entry in the setup.lst file

    File5=@msflxgrd.reg,$(AppPath),msflxgrd.reg,,6-30-10 10:02:01 PM,234,0.0.0.0

    2. Add msflxgrd.reg entry in the .ddf file so that the .reg file is packaged in the cabinet

    3. msflxgrd.reg file should have the registry entries viz:

    REGEDIT4

    [HKEY_CLASSES_ROOT\Licenses\72E67120-5959-11cf-91F6-C2863C385E30]
    @="ibcbbbebqbdbciebmcobmbhifcmciibblgmf"

     

    Deploy your package and have fun.

     

     

     

    Wednesday, June 30, 2010 5:43 PM