Using ExcelDNA form network share

[johansc...@gmail.com]

Hi there,

When I start the xll file form a network location Excel 2003 and 2007
crashes and will restart. I tried different locations and shares, all
the same. Locally on any pc it works fine. I've routed our policy with
templates to a networkpath for optimal management, but now I have to
copy the files to the local pc.

Johan

[gov...@icon.co.za]

Hi Johan,

Over a network path there is a restriction on the .Net code-access
security permissions, causing the exception you see.

There is a workaround whereby you locally set the share to full trust
- check this blog entry: Using CasPol to fully trust a share [ http://blogs.
msdn. com/shawnfa/archive/2004/12/30/344554.aspx ].
Basically you run the following from a Visual Studio command prompt:
CasPol.exe -m -ag 1.2 -url file://MyServer/MyShare/* FullTrust
You can also make the same change using the graphical .Net 2.0
Configuration tool in the control panel.

It is not so easy to handle this better in ExcelDna. The exception
occurs before any user code runs. I would have to write a completely
unmanaged shim and loader to be able to address this properly.

Regards,
Govert

[johansc...@gmail.com]

That explains! Thans Govert.

Johan

> > Johan- Hide quoted text -
>
> - Show quoted text -