View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Michael D. Reed Michael D. Reed is offline
external usenet poster
 
Posts: 8
Default Excel Automation Add-In does not show up in Function Dialog bo

Wei Lu

Running the script to update the code groups did not help. On the test
computers the add in is under My Computer | Runtime Security Policy | User |
Code | All_Code the add in is there with full trust. However, on the
development computer it is not there. I have some scene shots to explain
what the problem is if you give me a plce to send them it seems they are too
larg to post.. I there some setting in excel or module we are missing that
needs to be added to the test computer. This add-in is a direct copy form
Andrew book.

Mike Reed

"Wei Lu [MSFT]" wrote in message
...
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.)