Using .NET with VBA

[Guest]

Hi
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?
Regards
/Niklas

 

[Herfried K. Wagner [MVP]]

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?

 

[Guest]

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]]

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?

'Declare' won't work at all. I would register the DLL on the clients and
then reference it...