Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a COM Addin
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 "MSweetG222" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF when creating an Addin | Excel Discussion (Misc queries) | |||
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
Creating Excel Addin | Excel Programming | |||
Problems creating a dll in Excel 2003 using addin designer | Excel Programming | |||
Creating a new Excel Addin | Excel Programming |