Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation Add-In does not show up in Function Dialog box.
I have built a Excel Automation Add-In that provides in cell functions. When
I use it on the computer with the development environment it works fine. I can load it as an Automation Add-In and insert it into a cell using the insert function. How ever when I move it to a computer with just office w/Excel it can load it like an Automated Add-In. However, the name of the add-in or the functions name do not show up in the function list. This is built in VB.Net 2.0 and VSTO. I have installed both the VSTO runtime and the PIAs (Primary Interop Assemblies) on to the target computer. The add-in I properly registered. I have tried it with both a signed and unsigned assembly. Any ideas on what else to do or where to look? -- Mike Reed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation Add-In does not show up in Function Dialog box.
Hello Mike,
I would like to know whether you have loaded the Add-in and if you type the function in your cell, did the function works? Please let me know whether these KB article is helpful Excel fails when Automation add-In loads http://support.microsoft.com/kb/284876/ Excel COM add-ins and Automation add-ins http://support.microsoft.com/kb/291392 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.) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation Add-In does not show up in Function Dialog bo
Wei Lu
Yes I typed the name of the function in directly and I get a #NAME? error The first article did not help because Excel does not fail. The second article "Excel COM add-ins and Automation add-ins" was helpful but dated. I used two books: "Microsoft .NET Development for Microsoft Offrice" by Andrew Whitechaple Microsoft press "Visual Studio Tools for Office Usnig Visual basic 2005 with Excel, Word, Outlook, and InfoPath" by Eric Carter and Eric Lippert, Addison Wesley I would recommend both Following the instructions explicitly in both, to build add-ins and as I said they work just find on the development computer. However, when moved to a computer with out the development environment they appear as an Automated Add-in yet do not show in the insert function dialog box of Excel. I am at a loss of where to look next. -- Regards, Mike Reed "Wei Lu [MSFT]" wrote: Hello Mike, I would like to know whether you have loaded the Add-in and if you type the function in your cell, did the function works? Please let me know whether these KB article is helpful Excel fails when Automation add-In loads http://support.microsoft.com/kb/284876/ Excel COM add-ins and Automation add-ins http://support.microsoft.com/kb/291392 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.) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation Add-In does not show up in Function Dialog bo
Hello Mike,
I would like to suggest your chek the following things first: 1. You will have a GUID for your DLL in the automation add-in. Check if the GUID registered on the machine 2. Check if the registry key HKEY_CLASSES_ROOT\CLSID\<CLSID\Programmable exists Here are some related articles: FIX: Add-ins, smart documents, or smart tags that you create by using Microsoft Visual Studio 2005 do not run in Office http://support.microsoft.com/kb/908002/en-us FIX: You cannot run a customization that was created in Microsoft Visual Studio http://support.microsoft.com/kb/908004/ Deployment of Managed COM Add-Ins in Office XP <http://msdn.microsoft.com/library/de...-us/dnoxpta/ht ml/odc_shim.asp Using the COM Add-in Shim Solution to Deploy Managed COM Add-ins in Office XP http://msdn.microsoft.com/library/de...us/dnoxpta/htm l/odc_comshim.asp Information about designing Office XP add-ins and Office 2003 add-ins by using the .NET Framework http://support.microsoft.com/?id=840585 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.) |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation Add-In does not show up in Function Dialog bo
Hi ,
How is everything going? Please feel free to let me know if you need any assistance. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to not show save dialog after reading from excel file. | Excel Programming | |||
Help - Excel Automation: Turning off all dialog boxes (prompts). | Excel Programming | |||
Excel FileSaveAs dialog freezes when used via automation from Access | Excel Programming | |||
Turn off printing status dialog with Excel automation | Excel Programming | |||
Can't get Excel SaveAs dialog to show | Excel Programming |