[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

DllRegisterServer entry point was not found

Posted on 2013-01-19
6
Medium Priority
?
935 Views
Last Modified: 2013-01-22
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
Comment
Question by:gokyo66
  • 3
  • 3
6 Comments
 
LVL 17

Accepted Solution

by:
andrewssd3 earned 2000 total points
ID: 38797209
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
 

Author Comment

by:gokyo66
ID: 38800326
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
 
LVL 17

Assisted Solution

by:andrewssd3
andrewssd3 earned 2000 total points
ID: 38800677
I think you do need to follow all the suggestions - that error is a COM error - see: http://support.microsoft.com/kb/828550
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:gokyo66
ID: 38801510
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
 
LVL 17

Assisted Solution

by:andrewssd3
andrewssd3 earned 2000 total points
ID: 38804507
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
 

Author Comment

by:gokyo66
ID: 38804526
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question