All geek questions in one place

Is it possible to create a 64-bit add-in for the VBA IDE using IDTExtensibility2?

Is it possible to create a COM add-in that will load into the Visual Basic editor for the 64-bit version of Office 2010? I can get the add-in to load into the 32-bit version of Office 2010, but it is simply ignored by the 64-bit version.

EDIT: In my research, I found that many popular VBE add-ins do not work for 64-bit Office (e.g. Code Cleaner, MZ Tools, VBE tools, etc.). Some of them will be related to the fact that they are built on 32-bit VB6, but does anyone know about any VBA IDE add-in that works in 64-bit Office?

+4
source share
1 answer

You can load the add-in to a VBA environment. The trick is to put the registry entries in HKEY_CURRENT_USER \ Software \ Microsoft \ VBA \ VBE \ 6.0 \ Addins64 \ MyVBAAddIn.Connect, not HKEY_CURRENT_USER \ Software \ Microsoft \ VBA \ VBE \ 6.0 \ Addins \ MyVBAAddIn.Connect

Carlos J. Quintero has a detailed set of instructions at http://www.mztools.com/articles/2012/MZ2012013.aspx

+4
source

Source: https://habr.com/ru/post/1398964/

More articles:


All Articles