Using a VB.Net Class in vba (Access DB)

[Mark]

I want to develop a class using VB.Net that can be used in a vba procedure of
an Access database.

After developing the class in VB.Net I believe I have to do the following:
a. Compile the class.
b. Register the class.
c. Set a reference in the vba
d. Instantiate the class in the vba

I'm definitely a newbie in this area. So step by step instructions would
definitely be a plus.

Thank you for your help.

Mark

[Herfried K. Wagner [MVP]]

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Herfried K. Wagner [MVP]]

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Mark]

Herfield -

Thanks for the links. They are helpful, but...

For someone (like me) who has not actually worked thru the process, there
seems to be so many words and steps that it is overwhelming. You almost
don't want to try for risk of messing up the computer.

I will try "Googling" the subject to see if there is any additional
discussion.

Thank you for your comments.

Mark

"Herfried K. Wagner [MVP]" wrote:

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Mark]

Herfield -

The second link you suggested looks very promising.

I'll try it and let youknow how I did.

Thanks, Mark

"Herfried K. Wagner [MVP]" wrote:

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Mark]

Herfield -

Thanks for the links. They are helpful, but...

For someone (like me) who has not actually worked thru the process, there
seems to be so many words and steps that it is overwhelming. You almost
don't want to try for risk of messing up the computer.

I will try "Googling" the subject to see if there is any additional
discussion.

Thank you for your comments.

Mark

"Herfried K. Wagner [MVP]" wrote:

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Mark]

Herfield -

The second link you suggested looks very promising.

I'll try it and let youknow how I did.

Thanks, Mark

"Herfried K. Wagner [MVP]" wrote:

"Mark" <Ma**@discussions.microsoft.com> schrieb:

I want to develop a class using VB.Net that can be used in a vba procedure
of
an Access database.

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>