Problem adding References to Excel VBA App

[smadadi]

Hello,

I am trying to integrate Excel with Simply Accounting through VBA. In the Simply Accounting documentation it says to add references to the following DLL files:
- Simply_ConnectionManagerService.dll
- Simply_ConnectionManagerServiceClient.dll

I went to the references screen in VBA for Excel and these dll files were not listed in the scrollbox. I went to browse and found them in the simply accounting directory under program files, then tried adding them manually. An error message was shown saying that reference cannot be added to the specified file.

Anyone have any ideas on how to add these files as references?

[Kenneth Hobs]

Welcome to the forum!

Sounds like they were not properly created. You will need to contact the vendor. These usually fail when you register them from Start > Run > RegSvr32 yourDLLFilename.dll > OK

Some DLL's are not used from the object in Tools > References. e.g. API functions. You have to define and use them in another manner other than ActiveX methods.

Some DLL's can be used indirectly if you create TLB files from them. .NET provides some utilities that will create TLB files for you. These would then be referenced instead of the DLL.