runtime interop exception

[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.runtime interopservices .COMexception (0x80020011) does not support a
collection
at System.Runtime. Type.ForwardCal lToInvokeMember (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!

--
Message posted via DotNetMonster.c om

http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-vb-net/200606/1

[Leon Mayne]

RE: runtime interop exception

> the machines im trying to install the application on, are a windows xp[color=blue]
> professional running excel 2003, and windows xp with excel 2000.[/color]

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/d...displaylang=en

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