Creating a COM Addin

[MSweetG222]

I recently purchased "Professional Excel Development" by Bullen, Bovey and
Green. I am working on Chapter 21 – Writing Add-ins with Visual Basic 6. I
created the Hello World COM Add-in, published it and tested it. The program
works as described in the book.

My issue comes when I try to perform the File > Make HelloWorld.DLL step.

I receive the following error >>> Error in loading DLL
(no description as to which dll).

I have researched the web, and none of the info (so far) seems to addresses
my issue.

My system/settings: XP Professional, Excel XP (w/ Adobe's PDFMaker 7.0 tool
bar), macro security set to ‘low’, trust access to VB Project = true, trust
all addins = true. I have references to appropriate libraries (VBA, OLE,
Add-in, Office 10 Object, Excel 10 Object).

What I have done so far:
1. I have run the Regsvr32 process on the above libraries to re-register
them. (I did receive an entry point error on the Excel Object library - the
error message said it was because the file was not a .dll or .ocx).

2. Reinstalled Excel XP.

3. Reinstalled Office XP Developer.

Could anyone point me in a direction of what to do?

Thanks for any assistance.

MSweetG222

 

[Peter T]

What do you mean by you "published and tested it", was that by pressing F5
to run from the VB IDE then starting Excel. You might be able to test like
that before making the dll, but I assume "published" means you'd already
made the dll (or does it).

My issue comes when I try to perform the File > Make HelloWorld.DLL step.
I receive the following error >>> Error in loading DLL

You make the dll in VB, are you saying you get that message after pressing
File > Make...
I often get that message in VBA, typically after switching running from the
VBIDE <> dll and sometimes means re-starting Excel. But I've never seen it
while trying to make a dll in VB. Seems strange but the problematic dll
would be one of the references that was added to the VB project by default
after creating the a new 'addin' project, in VB > Project > References. Is
there anything inconsistent between the current user status for Excel & your
VB.

Regards,
Peter T