Can't find project or library while refer an external class library DLL file to VBA

Question

0.00/5 (No votes)

See more:

I have an Excel template ,that needs to be validated the user data with our DB.
For that I made a class library and where I added all validate functions,with the connection string also hard coded in the class,then I made a reference the class library DLL to the VBA.

While running the macro the functionality all are working as expected in my system!.
Unfortunately when this template checking in another system it says

Can't find project or library

What I have tried:

I tried it for using the reference by programmatically but none of those helped me
excel - How to add a reference programmatically - Stack Overflow[^]

Posted 30-Oct-17 4:45am

soumyaraj

Updated 4-Dec-17 19:54pm

Add a Solution

Comments

FranzBe 30-Oct-17 10:57am

Sounds like your dll is dependent on something that is missing in the 'other system'. I would try to monitor the start of your macro with process monitor or with dependency walker
https://docs.microsoft.com/en-us/sysinternals/downloads/procmon
http://www.dependencywalker.com/

F-ES Sitecore 30-Oct-17 11:43am

Have you registered the class library on the system? Just having the dll there isn't enough if it's a COM object.

RedDk 30-Oct-17 16:34pm

I see your link to SO ... but have you tried "adding" the "reference" manually?

soumyaraj 31-Oct-17 5:19am

I have referred the following link to develop the class library and the connection string could more secure.But when I copy the .xltm file in to another system and when running the macro, it shows the error 'can't find project or library'.
Let me know the class library dll also needed in the client machine and make reference again?

https://stackoverflow.com/questions/3217014/how-to-securely-store-connection-string-details-in-vba

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2017-12-04T19:54:00

few tips here which I have tried when I had the same issue

1) Check that the new solution's projects run against a compatible framework to the project you're trying to include. I was trying to include a reference to a 4.0 project in a 3.5 project.

2) Try the normal cleaning of the projects and rebuilding, shutting down all Visual Studio instances and restart them

3) One possibility is that the target .NET Framework version of the class library is higher than that of the project.

4) Try to clear caches
tools->options->resharper->options-> general-> click the clear caches button and restart VS