Excel Interop > ActiveX>SEcurity exception

[Graeme]

[VB.NET 2003 XP Pro SP2 .NET FrameWork 1.1]
I am using the MS Office PIA to create an Excel Microsoft Office System
Project.
I have added a menu button to the Excel spreadsheet. When clicked this
displays a form that contains a COM ActiveX control (ComponentOne Query8)

When I instantiate my form (from the OfficeCodeBehind class) which has
C1QueryFrame controls & a C1Query control on it I get a
System.Security.SecurityException exception generated with the message
"Request Failed"

ie Dim myForm as new MyQueryForm generates the exception

Are there any known issues with using ActiveX/COM controls from an Excel
..NET project?

It is fine when used from a normal windows application.

The only way around this that I have found so far is to turn off .NET
Security using:
caspol -s off

My .NET framework configuration assigns full control to all assemblies on
MyComputer, which where all this is running.
TIA,
Graeme Hart

 

[Graeme]

I have found the solution. It is desribed in this article:
http://msdn.microsoft.com/msdnmag/issues/04/03/ToolsforOffice2003/default.aspx

It is all down to the .NET Framework security policy for the user and the MS
Office Excel .NET Project.
I changed the Trust Level on MyApp_Bin from Execute to FullTrust and now my
form appears OK.

Graeme