none
Issue with flexgrid in excel 2010 64-bit (VBA7)

    Question

  • Hi,

    I am upgrading a Excel VBA6 application to Excel 2010 VBA7 64-bit application.
    My application uses Microsoft FlexGrid. After upgrading the code, I am facing issue with this MSFlexgrid.
    I have found that using 32-bit ocx file dindot solve this issue. 
    I have googled regarding this issue, but all sites have told me that there is no 64-bit version for msflxgrd.ocx or usage of some third party dlls.
    But, I dont wish to use third party dlls in my application.

    Is there any fix for this.

    Thank you in advance.

    Regards,
    Adithya
    Monday, November 18, 2013 1:45 PM

Answers

All replies

  • Hi Adithya,

    You will have to find someone who can program a flex-grid look-a-like in VBA. Like we did for the treeview control:

    http://www.jkp-ads.com/articles/treeview.asp


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Tuesday, November 19, 2013 5:22 AM
  • Hi Jan,

    Thanks for your reply Jan. But is there any other way/ workaround .

    I ask this because, I think finding someone is not very easy.

    Regards,

    Adithya

    Tuesday, November 19, 2013 6:21 AM
  • Hi Adithya,

    No, there seems to be no 64 bit version of the flexgrid control so if you insist on using a control like that it will have to be programmed.

    I could certainly pull this off, but it would be expensive!

    The only alternative I know of is porting your application to .NET.


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Tuesday, November 19, 2013 8:29 AM
  • Hi Jan,

    If porting is the only alternative then could you share  more information regarding this porting.

    We are using Flexgrid object in Windows forms that in turn call functions declared in Excel. 

    How could I possibly do this with a .NET ported dll. 

    Regards,
    Adithya

    Tuesday, November 19, 2013 10:05 AM
  • Hi Adithya,

    Depends. in what programming environment was this dll developed?


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Tuesday, November 19, 2013 10:25 AM
  • Hi Jan,

    The application where use Flexgrid is not a dll, but in Excel VBA, if that is what you asked.

    I had doubt regarding the idea of porting to .NET. If we port Flexgrid to .NET, then how would I create Flexgrid controls in Excel using the ported .NET dll.

    Regards,
    Adithya

    Tuesday, November 19, 2013 10:45 AM
  • Hi Adithya,

    You would have to port the vba code to VB.NET and re-create the userforms as Windows forms in VB.NET, which (I expect) will have some sort of flexgrid control.

    It might be easier to look for alternatives, such as a plain listbox instead of the flexgrid :-)


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Tuesday, November 19, 2013 12:32 PM
  • Hi Jan,

    Thanks for your answer. I will look into implementation with liost box and try to replicate the functionality of flexgrid. 

    Regards, Adithya

    Tuesday, November 19, 2013 1:20 PM