topic restricted COM interface anyone? in Software Archive

restricted COM interface anyone?

rahzan — Thu, 15 Nov 2001 03:17:49 GMT

I have written a com server which uses assumed array inputs. however VBA (in ms access) givz the following compile error:
"Function or interface makred as restricted, Or the function uses an automation type not supported in Visual Basic"

Any hints as to wut the heck this means, will be most appreciated.

Tim

Re: restricted COM interface anyone?

Intel_C_Intel — Thu, 15 Nov 2001 07:55:39 GMT

Hi,

It's probably the "automation type" that it is complaining about. I don't remember about VBA, but I thinlk VB Script requires most arguments to be of type VARIANT. If that is the problem, you would have to change the data type to be VARIANT and get the SAFEARRAY from the VARIANT and deal with it as a SAFEARRAY.

The other (easier) thing to check is to make sure that the intent of your array argument is INOUT.

Leo

Re: restricted COM interface anyone?

rahzan — Thu, 15 Nov 2001 08:14:33 GMT

Thanks,
Methinks, intent=IN did it though why would it even be an allowed option if it fails (perhaps just for VBA??). INOUT works now.

Tim

Re: restricted COM interface anyone?

Intel_C_Intel — Fri, 16 Nov 2001 03:08:56 GMT

It's an option becuse it is only a VB restriction - VC, VF, and maybe other COM clients can handle an intent IN array just fine...

Leo