Click to See Complete Forum and Search --> : Interfaceproblems in VBA


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