View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Wei Lu [MSFT] Wei Lu [MSFT] is offline
external usenet poster
 
Posts: 70
Default 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/de...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/lib...t0(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/subscripti...ult.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/subscripti...t/default.aspx.

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