Gustav Brock
Gustav at cactus.dk
Wed May 10 04:19:51 CDT 2006
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