Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Interop ActiveXSEcurity exception
I have found the solution. It is desribed in this article:
http://msdn.microsoft.com/msdnmag/is...3/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 "Graeme" wrote: [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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Immediate Fail: Launch Excel via Interop | Excel Discussion (Misc queries) | |||
Microsoft.Office.Interop.Excel when exporting from another program | Excel Discussion (Misc queries) | |||
Activex control security message | Excel Programming | |||
Displaying multiline Text into Excel Cell through Interop | Excel Programming | |||
Excel Workbook opened twice with dotnet interop | Excel Programming |