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