Hi all,
I'm trying to add functions to Excel 2000 via VBA's Declare. I have 
declared the interface in VBA and the C++/CLI-dll ("Excel-AddIn.dll") 
works normally, if I use standard types and SAFEARRAY, __stdcall and a .def.

After adding a reference to Excel9.olb (creates Interop.Excel.1.3.dll, 
Office.dll and VBIDE.dll) and using Excel::Range within a procedure, I 
have problems loading the Excel-AddIn.dll, because Interop.Excel.1.3.dll 
or one of it's descendants cannot be found. If I copy the interop-dlls 
to the Excel directory, the dll can be loaded.

Question 1:
I assume I have to modify the Excel-AddIn.dll.manifest file to give the 
correct location of the interop-dlls. How?

If my Dll exports a function with Excel::Range^ as an argument (no more 
__stdcall possible) I get a 0x80004005 COM-error.

Question2:
What's the problem here?


Thanks for any ideas,
Christian


Example
=======
VBA:
Public Declare Function SumMe Lib "Debug\Excel-AddIn.dll" Alias "SumMe" 
(ByRef r As Range) As Double

Private Sub Workbook_Open()
     ChDrive Me.Path
     ChDir Me.Path
End Sub


C++/CLI:
extern "C" {
   double SumMe(Excel::Range^ r) {
     ..
   }