Home All Groups Group Topic Archive Search About

runtime interop exception

Author
21 Jun 2006 4:38 AM
m.ra. via DotNetMonster.com
hi

ive written a database management application and am trying to deploy the
same. the program works perfectly on my machine - a windows xp (home edition)
with office 2002. (i also compiled the program on the same machine)

the machines im trying to install the application on, are a windows xp
professional running excel 2003, and windows xp with excel 2000. i keep
getting this error message on the two systems:

"System.runtimeinteropservices.COMexception (0x80020011) does not support a
collection
    at System.Runtime.Type.ForwardCallToInvokeMember (String Membername,
Binding Flags, object target, Int 32[]
at wrapper types, Message Data & msgdata)
  at Excel.range.set_value (object range valuedatatype. object)"

im thoroughly lost as to what that means and what to do about it. could
someone please help? thanks!


Author
21 Jun 2006 1:00 PM
Leon Mayne
> the machines im trying to install the application on, are a windows xp
> professional running excel 2003, and windows xp with excel 2000.

You may need to download the Office Primary Interop Assemblies and compile
against those. I'd suggest using the highest version you are going to deploy
against, so maybe: http://www.microsoft.com/downloads/details.aspx?familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en

I don't have much experience using the PIAs though, so can't help you much
more.