View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default Creating a COM Addin

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