none
Issue with ListView RRS feed

  • Question

  • We are developing a prototype model in Excel/VBA with a complex user interface that relies on several objects. One of the most used objects is the ListView. Unfortunately we realized that the code runs correctly on 32-bit machines, but does not run on 64-bit machines. In particular, it seems that the object/class "ListView" is not recognized/supported on Microsoft Office Professional Plus 2013 on Windows 8.1 64-bit.

    Please notice that we have installed on both machines all the required packages, including Microsoft Windows Common Controls 6.0 and both systems do not detect any missing package/reference.

    Is there a way to solve the issue without deeply modifying the current code and structure of the user interface? We need to be able at any time to run the model on both 32 and 64-bit machines.

    Thanks

    Elio

    Wednesday, October 4, 2017 9:45 AM

All replies

  • The common controls should work OK in 32-bit Office on both 32-bit and 64-bit Windows. But ActiveX controls won't work in 64-bit Office.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, October 4, 2017 10:00 AM
  • We are using ListViw (which is an ActiveXcontrol). Is there a similar object which we can use instead of ListView? Which is the workaround?

    Wednesday, October 4, 2017 10:09 AM
  • If possible, use a ListBox control instead of a ListView control.

    The 64-bit alternatives are commercial (not free):

    Pro ListGrid: see the link near the bottom of http://www.jkp-ads.com/Articles/treeview.asp

    Studio Controls COM 64: https://www.dbi-tech.com/ProductPage_studiocontrolscom64.aspx


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, October 4, 2017 2:54 PM
  • Thanks.

    The issue with ListBox is that it does not have the same properties, so we would need to adapt the algorithm (which in this case means changing a lot of features of the user interface). 

    With the commercial alternatives we would need to change the code anyway, right? Those do not allow to run the ListView on our machines but imply changing the objects. Is this intuition correct?

    Wednesday, October 4, 2017 3:43 PM
  • Yes, with the commercial alternatives you'd have to rewrite part of your code...

    Is there any chance of avoiding 64-bit Office? That would be by far preferable...


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, October 4, 2017 9:34 PM