Using .NET Classes in VBA 6 code, possible or not?

2 Mar 2007 10:08 AM

// Peter

Hi Experts!

Need to know if the following is a possible way of doing it; in VBA 6
(actually in Access 2000 visual basic module) code use .NET 1.1 or 2.0
Classes. Development application is Visual Studio .NET 2003 (canâ€™t afford to
upgrade if you asks/wonder why I use this obsolete Studio).

Please be so kind and give me a link or what ever to follow up.

Regards from
// Peter

2 Mar 2007 2:31 PM

Norman Yuan

You can expose your .NET1.1 (since you use VS2003, you can only work with
..NET1.1) dll through COM Interop, then you can reference the COM-able .NET
dll just as regular ActiveX in your VBA project. Note, the computer must
have .NET 1.1 or later installed.

Show quote

"// Peter" <engstrom_pe***@hotmail.com.(donotspam)> wrote in message
news:04E4F2C5-E2E4-4AA4-9F76-E8E3AAC35AA6@microsoft.com...
> Hi Experts!
>
> Need to know if the following is a possible way of doing it; in VBA 6
> (actually in Access 2000 visual basic module) code use .NET 1.1 or 2.0
> Classes. Development application is Visual Studio .NET 2003 (can't afford
> to
> upgrade if you asks/wonder why I use this obsolete Studio).
>
> Please be so kind and give me a link or what ever to follow up.
>
> Regards from
> // Peter
>

6 Mar 2007 3:37 AM

Patrick Steele

In article <04E4F2C5-E2E4-4AA4-9F76-E8E3AAC35***@microsoft.com>,
engstrom_pe***@hotmail.com. says...

> Hi Experts!
>
> Need to know if the following is a possible way of doing it; in VBA 6
> (actually in Access 2000 visual basic module) code use .NET 1.1 or 2.0
> Classes. Development application is Visual Studio .NET 2003 (canâ¤=3Ft afford to
> upgrade if you asks/wonder why I use this obsolete Studio).
>
> Please be so kind and give me a link or what ever to follow up.

http://www.15seconds.com/issue/040721.htm

--
Patrick Steele
http://weblogs.asp.net/psteele