[AccessD] Call .Net 2.0 Framework code from Access VBA

MartyConnelly martyconnelly at shaw.ca
Wed May 10 09:49:48 CDT 2006


Now I just have to sort out the deployment issues.
You need to set a reference to the .tlb file but you have
to register the .dll on the client machine
to get at the class GUID's in the COM registry.

Gustav Brock wrote:

>Hi Marty
>
>This is very interesting. Thanks a lot for that link!
>
>/gustav
>
>  
>
>>>>martyconnelly at shaw.ca 09-05-2006 21:45 >>>
>>>>        
>>>>
>This might be interesting and is fairly simple
>
>Call Into The .NET Framework From Existing Visual Basic 6.0 Apps
>http://msdn.microsoft.com/msdnmag/issues/06/05/WrapItUp/default.aspx 
>
>This article adresses VB6 but there is no reason, it can't be used from VBA
>You will need VB Express installed along with .Net Framework 2.0
>to create the wrapper dll. And perhaps register as COM object.
>
>It should save you using a lot of 3'd party controls by using the
>NET Framework class library instead. There are a lot of things
>that can be quickly written in .Net
>
>The .NET Framework classes must be called through a wrapper.
>The wrappers are built using the COM Class item in VB Express,
> and they behave like any other COM objects
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list