Compile error with VBHTMLMaker.xla

[batman37]

When I click Compile VBHTMLMaker under Debug in the VBE a compile error appears in the Initialize Sub, specifically in the 8th line: Set Obj = Choose(j, Application.VBE.CommandBars.......

The error message is "Error in loading DLL", and the debug marker homes in on .CommandBars . There is no information about the DLL that isn't loading properly (or at all). It may be missing or corrupted, but I can't tell.

Although I have very little experience with add-ins, I am able to write and deploy macros with no problems like this one. I run Excel 2003 under WinXPSP2 with all updates.

Can someone tell me what I'm missing or doing wrong, or point me in the right direction?

Thanks, batman37

 

[apolinary]

Hi,
I managed to correct the VBHTMLMaker.xla. In my case it was incompatibility with x64 architecture.
However, I am not sure if it solves your problem. Anyway - you need to correct the function declaration to:

#If Win64 Then
    Private Declare PtrSafe Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
#ElseIf Win32 Then
    Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
#End If

 

[apolinary]

 

[Peter_SSs]

@apolinary

Are you aware that you are addressing a post that is 13 years old!!?

Since then the forum software has changed and there is no need for the VBHTML Maker in the forum any more since you can now just copy/paste your code using the vba code tags - just as you did in post #2. So there is actually no need to correct anything for use in this forum.