VBA HTML Maker add-in not working

[sapka]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am using Excel 2010 (64-bit). For some reasons I cannot successfully use VBA HTML Maker add-in (www.mrexcel.com/vbaddin.shtml). I get several errors, one I have fixed with adding PtrSafe, but I still have problems. To be more precise this line fails (error 438):<o></o>

Set cBtn.BtnEvents = Application.VBE.Events.CommandBarEvents(Btn)

How this add-in can be fixed?<o></o>

 

[bertie]

The Object Browser shows that to use VBE.Events, you need a reference to:

Tools => References => Microsoft Visual Basic for Applications Extensibility 5.3

 

[sapka]

It seems that this reference is not available. Where can I get it from?

 

[bertie]

Here is the filename and the file location on my pc.

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

Generic name: Microsoft Visual Basic for Applications Extensibility 5.3

You should be able to get it from the Microsoft website.

 

[sapka]

Ok, I have successfully referenced it. Now menus are created. However during the creation process I still receive the same error and created buttons seem to be inactive (do not work).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[bertie]

This is the add-in I use. My MSOffice is a 32bit version and I have no problems.

Afte a quick Google search I found a possible explanation from this site:
http://msdn.microsoft.com/en-us/library/ee691831.aspx

Native 64-bit processes in Office 2010 cannot load 32-bit binaries. This is expected to be a common issue when you have existing Microsoft ActiveX controls and existing add-ins.

This, I'm afraid is way over my head.