Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 936
  • Last Modified:

DllRegisterServer entry point was not found

Hello Experts,
let me tell you that before ask a new question I read the other question based on same subject. I understand few things, but I guess I missing the main point.

I create a very simple dll via Visual Studio I tried in C# and in VB but same results.
This class is very simple it return a String with "Hello World"

When I compiled with no error I go in the folder I take the file.dll I copy in another folder an I open Excel VBA and in the Reference I try to add that library as dll and there I got the first error, so I thought that I have first to register so I tried via regsvr32, using regasm in both cases I got back error, using regsvr32 I got back the error that is in the topic of this post.

So basically let say as other experts replyed that maybe the dll is not meant to be registerd, anyone can then explain me how can I use it in Excel VBA?
0
gokyo66
Asked:
gokyo66
  • 3
  • 3
3 Solutions
 
andrewssd3Commented:
To use a dll from VBA it needs to be COM visible so it can interact properly.  This is not too difficult but a bit fiddly - this article is one of many that gives instructions (Google for others): http://msdn.microsoft.com/en-us/library/vstudio/bb608604.aspx
0
 
gokyo66Author Commented:
Hi andrewssd3,
thank you for your reply, Im just making some test.

Acutally it seems more easy than what described in your link. I just compiled my project with the flag "Register for COM interop" so when compiled I got now a file .tlb.

When now I go in Excel VBA I can import without error the reference, I can as well create a variable of this type, I got back now another error "Runtime error 429"
0
 
andrewssd3Commented:
I think you do need to follow all the suggestions - that error is a COM error - see: http://support.microsoft.com/kb/828550
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
gokyo66Author Commented:
Well I tried as well with the info on the new link but still I got back the error 429 --- don't know... I don't get how a so simple thing get so complicated and annoyoing... anyway
0
 
andrewssd3Commented:
Yes - difficult to help without being able to see what you're doing.  I have done this before by following instructions found on the web - can't remember exactly which one, but here's another: http://stackoverflow.com/questions/1170794/a-simple-c-sharp-dll-how-do-i-call-it-from-excel-access-vba-vb6.  You could do some more googling...
0
 
gokyo66Author Commented:
Hi andrewssd3,
you know what... you're right, actually I was a little in hurry to do something so at the end I create a virtual machine I installed window XP and then Visual Studio a version of the 1999 with Visual Basic 6 I created a DLL and works perfectly, no registration needed, just put the dll in the folder of the Excel programm I did.

Now said that is pretty a pity if not sad, that I had to do that to solve my problem, in any case I will follow again your precious instruction, maybe with less pressure I can see better and read better.

So basically I accept your first solution, and I thank you very much for your support

Best Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now