RE: Excel Automation Add-In does not show up in Function Dialog bo

Hello Mike,

Thanks for the update.



You can grant permissions to assemblies using Code Access Security Policy
tool (Caspol.exe) or you can add a custom action to the setup project.

Use Caspol.exe to create a code group for the assembly

1. Create a batch file with the following contents and save the batch file
as "SecuritySetup.bat":

++++++++++++++++++++++++++++++++++++

@rem - polchgprompt - Enables or disables the prompt that is displayed

@rem - whenever Caspol.exe is run using an option that

@rem - would cause policy changes.

@rem - addgroup - Adds a new code group to the code group hierarchy.

@rem - url - Specifies code that originates from the given URL.

@rem - name - specifies the scripting name for a code group to add.



CD \

PATH=%windir%\microsoft.net\framework\v2.0.50727

caspol.exe -polchgprompt off -u -addgroup All_Code -url <filepath>
FullTrust -name "Word Addin Assembly"

caspol.exe -polchgprompt on

Pause

++++++++++++++++++++++++++++++++++++++++



2. At a command prompt, execute the batch file:



Add a custom action to the setup project

Here are a step-by-step article for your reference.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto200
3_tr/html/odc_VSTMGBLab5.asp


Here are some related links about VSTO and deploy Office solutions. I hope
it will be helpful to you.


1. Microsoft Visual Studio Tools for the Microsoft Office System

http://blogs.msdn.com/vsto2/

2. Configuring Security Policy Using the Code Access Security Policy Tool
(Caspol.exe)

http://msdn2.microsoft.com/en-us/library/a0ke3k86.aspx

3. How to: Grant Permissions to Folders and Assemblies

http://msdn2.microsoft.com/en-us/library/zdc263t0(VS.80).aspx



Please feel free to contact me if I can be of further assistance.

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

.

Relevant Pages

  • RE: assembly doesn permit partially trustets calls
    ... Full Trust permission set of (unrestricted permission to do anything it ... we can give all the assemblies in the ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework)
  • Re: assembly doesn permit partially trustets calls
    ... To mitigate the risk, think very carefully about the permissions that you assign to the application running on the file share so that it permits exactly and only the request to satisfy the permission demand, block everything else. ... we can give all the assemblies in the ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework)
  • RE: Calling a Dot Net DLL from MS Access
    ... Still publish the assembly in the network share, ... all the assemblies in intranet shares (not ... Here are the basic steps to create such a setup project: ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.interop)
  • RE: Erro when execute applicatin compiled in vc2005 in Windows Server 2003 - PLEASE HELP
    ... I have checked your sample application with the Dependency Walker, ... if you generate a VS2005 setup project for your application(add ... Microsoft Online Community Support ...
    (microsoft.public.vc.language)
  • Re: assembly doesn permit partially trustets calls
    ... I have to try the solution in the web page from microsoft. ... Full Trust permission set of (unrestricted permission to do anything it ... we can give all the assemblies in the ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework)