VonPookie HELP!!!

[TrippyTom]

I am calling upon the powers that be to inform them of my plight with VBE HTML Maker. It doesn't seem to have a FAQ like the normal HTML Maker does.

I'm getting the following error window when trying to install the add-in:
Compile Error:
Error in Loading DLL
[OK][Help]

and if I go to the code, it's stopping on the Set Obj line here:

Public Sub Initialize()
    Dim Btn As CommandBarButton, Obj As Object, cBtn As clsBtn
    Dim i As Long, j As Long
    Terminate
    Set Col = New Collection
    For j = 1 To 2
        On Error GoTo err_h
        Set Obj = Choose(j, Application.VBE.CommandBars.FindControl(ID:=30007), Application.VBE.CommandBars("Code Window"))
        With Obj

I'm running Office 2003, SP2.

 

[Von Pookie]

Eeeeesh. I have no idea. I don't know the technical stuff so much as I do how things work with the board--and even then, I'm no expert on the matter.

On top of that, I haven't used the VB HTML Maker in a long, long time.

I would suppose a good place to start would be to do a Google search on the error message itself, see what comes up, though. That's about all I can do. I do not have a copy of 2003 installed to test it.

 

[NateO]

What's your Security Settings like?

Like this?

Click OK to close the dialog box with the error and go to Tools->Macros->Security. Click the Trusted Sources tab and check the box next to "trust access to Visual Basic Project," and click OK.

Stab in the dark here...

 

[TrippyTom]

Hi Nate,
BOTH of those checkboxes are enabled. Should they not be?

 

[NateO]

Yes, they should be. Actually, this file tests for that:

http://www.mrexcel.com/vbaddin.shtml

Are you using this file? I can't find the procedure you're referring to in there...

I see this, but it's not the same:

'Put the buttons in the VBE Tools menu
Sub CreateBar()
    Dim Btn As CommandBarButton, Obj As Object
    Dim i As Long, j As Long
    DeleteBar
    For j = 1 To 2
        On Error GoTo err_h
        Set Obj = Choose(j, Application.VBE.CommandBars.FindControl(ID:=30007), Application.VBE.CommandBars("Code Window"))

You might want to swap files? Not sure, works fine for me in xl 2003...

 

[TrippyTom]

Hi Nate,
Yes, it's the same file. Just to make sure, I downloaded it again, and wrote over my addin, and it still errors at the same point.

It's under the CLASS MODULES > clsBtn code. Does that help narrow it down a little?

 

[TrippyTom]

However, if I cancel out of that, and try to use the addin, it seems to be working!

book2
	A	B	C	D
1	this	is	a	test
2	is	is
3	a		a
4	test			test
Sheet1

I have no idea what's causing this to trigger an error. I guess I can live with this happening only when I start Excel, it's just a minor annoyance.

I have a similar (related?) issue in a macro that tries to set calculation when Excel starts.

 

[NateO]

What's the name of the file that you're working with? Just to be sure...

 

[Von Pookie]

What Nate means is which add-in are we talking about?

You originally said this was a problem with the VB HTML add in, but the example you posted above is using the HTML Maker--not the VB HTML Maker.

So--which is it?

(I still really wish one of these were named differently. )

 

[TrippyTom]

Oh sorry, yeah my bad.
It's the VB one. The names confuse me all the time too.
The VB one is still NOT working. I guess it was wishful thinking on my part.