none
Using 64 bit active x controls developed in .net in VBA with 64-bit office. RRS feed

  • Question

  • We have an old excel VBA add-in that uses some active-x controls developed by us in .net.
    This excel add-in works well with 32 bit version of MS Office.
    Now we want this add-in to work equally well with 64 bit version of MS Office.
    For that first we need to build 64 bit version of our active-x controls, all goes well so far.
    But when we try to put those active-x controls on VBA user form (64 bit version of MS Office), it gives "Unspecified error".
    Also if we create the 64 bit Active-x control in VC++ then I am able to place and use that control on VBA user form successfully.
    I tried all possible options that I could and am clueless now.
    Any help or pointer in this direction would be much appreciated.

    PS : For now we are targeting MS Office 2010

    Thursday, August 9, 2012 2:28 PM

All replies

  • Choose the 32-bit or 64-bit version of Office

    No way to do that. x86 office controls not fit with x64

    When you make add-in using .NET you must use theirs controls


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Thursday, August 9, 2012 9:24 PM
    Answerer
  • Avatar of VBATools

    VBATools

    Veracomp SA

    MVP

    6,063 Points 19 6 0
    Recent Achievements
    Gallery Rater II Gallery Contributor II New Gallery Storyteller

    @Veracomp SA :

    I think there is some confusion here. I am not trying to use x86 active x control in 64 bit VBA add-in.
    What I am trying to do is creating x64 version of my active x control and trying to use that conrol in 64 bit VBA add-in.
    Even this use case is not working and giving me error.
    My active x control is developed in .net.


    • Edited by Mousam01 Friday, August 10, 2012 12:42 PM
    Friday, August 10, 2012 12:42 PM
  • I think that question you should put in VSTO Forum. You can find there people, created own controls Too.

    Sorry, I do not have experience with such a case.


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Sunday, August 12, 2012 6:21 PM
    Answerer