How to compile a VBNET .dll and use it as reference in Excel?

i am upgrading my VB6 application to VBNET.
I have Excel set up already with a reference to my VB6 dll and everything works fine.
when i finished correcting all the errors and warnings to upgrade my project to NET, i built it,  but now i can't find it in the Excel references. and when i browse to it i get an error "Cant reference the selected file".
please give me any guidance since im new to VBNET.
LVL 13
newyuppieAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

newyuppieAuthor Commented:
i need guidance in why i need to regasm the dll when in VB6 it was registered automatically. i also want to know whats this about strong names and how does this affect excel interoperability.
any suggestions?? even a link that i can read.
Bob LearnedCommented:
Here is an article that describes the steps to create a COM-capable .NET assembly:

Calling .NET From COM
http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=113

Bob

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
newyuppieAuthor Commented:
thats an article for C, but basically describes the steps very lightly.

after i regasm my dll, and try to call it with excel, i get "automation error: file or assembly not found". i registered it globally too and no luck.
do i have to use CREATEOBJECT in excel necesarilly? i've been trying to create the object like DIM myobj as NEW assembly.class, like ive always done when i use to make VB6 dlls, but no luck i get the automation error.
any suggestions?>
newyuppieAuthor Commented:
i accepted because i kind of found this out on my own, but i appreciate Bob's help. the link was very general, and C# not VBNET. the grade C was because of the generality of the link
thanks anyway
P
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.