Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

DllRegisterServer entry point was not found

Posted on 2013-01-19
6
915 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 500 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 500 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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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 500 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

856 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