Page 2 of 2 FirstFirst 12
Results 41 to 44 of 44

Thread: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

  1. #41

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2012
    Posts
    1,876

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Quote Originally Posted by southmark View Post
    I have 32-bit Excel, but how do I go about adding and using it? I added a reference to the ocx and tlb but cannot see a control to add to the palette in the form builder. What are the steps please?
    You don't need to reference ocx and tlb.
    Just right click add.. on the control toolbox for VBFlexGrid.

  2. #42
    New Member
    Join Date
    Jan 2019
    Posts
    12

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Quote Originally Posted by Krool View Post
    You don't need to reference ocx and tlb.
    Just right click add.. on the control toolbox for VBFlexGrid.
    Hi Krool, thanks for the response. I don't see the vbflexgrid in the toolbox. I don't have permissions to run regsvr32 on vbflxgrd14.ocx which was why I was hoping adding a reference to the ocx would do the trick. What am I missing here please?

  3. #43
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    4,699

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    The OCX needs to be registered on your machine before you can use it from VBA.

  4. #44
    New Member
    Join Date
    Jan 2019
    Posts
    12

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    How might I install the OCX control without admin rights? Anyone?

    I got rights temporarily, ran regsvr32 and verified that the control works - awesome!

    I then experimented with the Microsoft Regcap tool to capture a registry file.

    `RegCap /O vbflxgrd14.reg vbflxgrd14.ocx`

    I edited the file to change instances of HKEY_CLASSES_ROOT to HKEY_CURRENT_USER\Software\Classes as per a number of references. I also added the 'Windows Registry Editor Version 5.00' header line to the registry file. When run it was reported to have completed successfully.

    However, the control is not enabled in the control toolbox unless I again run regsvr32 as admin. Still investigating but it would be great to hear from someone who got this working.

    Thank you!




    Quote Originally Posted by Krool View Post
    You don't need to reference ocx and tlb.
    Just right click add.. on the control toolbox for VBFlexGrid.
    Quote Originally Posted by Arnoutdv View Post
    The OCX needs to be registered on your machine before you can use it from VBA.
    Thank you both for the replies. It had been a long time since I'd used VBA! Krool, this was amazingly single to switch out the microsoft control for, amazing project!

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width