Hi
I want to use a .NET dll from Excel. I'm going to add a reference to the dll
so the workbook know where the dll is. Is it possible to to use code to
create an object which is defined the .NET dll? I tried the DECDLARE
statement or GetObject with no luck. I want to know if I did something wrong
or if I try to do something impossible?
Regards
/Niklas
"Herfried K. Wagner [MVP]" wrote:
"Niklas" <Ni****@discussions.microsoft.com> schrieb: If I create a .NET dll and compile it with the option "Register forCOM
interop" I have no problem to us that dll in Office with VBA. The problem
is
that I do not want to register the dll on the client. I want to have the
dll
and the corresponding tlb on a shared network. Is it possible in one way
or
another to call a .NET dll with a corresponding tlb file on the network
thru
VBA with DECLARE, GetObject or something else?
How should the system know where to find the DLL?
--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>