View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graeme Graeme is offline
external usenet poster
 
Posts: 59
Default Excel Interop ActiveXSEcurity exception

[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