Akademos
March 13th, 2001, 07:25 AM
Hi,
i've wrote an ATL-Object which i will use in Excel. My object has an interface methods which has an array as parameter. The declaration of these method is:
[id(1), helpstring("Methode Values")] HRESULT Values([in]SAFEARRAY(BSTR) TheValues);
VC++ compiles this without complain.
if i add my interface to my Excel i get following error message:
Function or interface can't be used complete or uses a type of automation which isn't support by Visual Basic. The VBA-Code i use is following:
Dim strValues(200) as string
'Do some work with strValues here
rfcServer.Values (strValues)
Can anyone please tell me what i have to do to make this thing work.
thanks
akademos
i've wrote an ATL-Object which i will use in Excel. My object has an interface methods which has an array as parameter. The declaration of these method is:
[id(1), helpstring("Methode Values")] HRESULT Values([in]SAFEARRAY(BSTR) TheValues);
VC++ compiles this without complain.
if i add my interface to my Excel i get following error message:
Function or interface can't be used complete or uses a type of automation which isn't support by Visual Basic. The VBA-Code i use is following:
Dim strValues(200) as string
'Do some work with strValues here
rfcServer.Values (strValues)
Can anyone please tell me what i have to do to make this thing work.
thanks
akademos