Hi I am developing a Excel shared Add-in which has the menu called Custom which is created using Excel Macros. Now i want to create a submenu under the Custom menu using Csharp Shared Add -in. Iam using the below code for doing this but no help oStandardBar = oCommandBars["Custom"]; oCmdBarCtrl = oStandardBar.Controls.Add(MsoControlTy...
I am designing a Shared Add-in for Excel in Csharp and now i am adding the custom menu in OnStartupComplete event but now i want this to be moved to WindowActivate event. I have added the event but it is not firing. Please help me ...
Does anyone know how to use R1C1 reference style, inside the IDE for a VSTO Excel Workbook project? I cannot find it in google or in the solution, and the ribbon button thing is not available in the IDE spreadsheet. Also - side question - anyone know why when I imported an excel file, none of the lookups or conditional formatting or nam...
Hi I've been trying to figure out how to create a context menu in VSTO 2007. I'm hoping that is possible. When I make this call. Dim commandBar As Microsoft.Office.Core.CommandBar = _word.CommandBars("Text") I get the following error. This object model command is not available in e-mail. I've look all over and from what I can tell ...
I have a requirement to create an installer for an Outlook 2003 add-in that was created with VSTO. We currently are using Wix for our installers as they play nice with MSBuild and I need to use it to create the installer for the outlook add-in. I have no experience with outlook add-ins and am unsure exactly what is involved and how to ...
Hi, I've got a .net 3.5 vs2008 Excel addin. I've created an installer for it and have it working apart from the fact that I cant get an option in the prerequisites for VSTO 3.0 SP1. I have one for VSTO 3.0 and when I check the C:\Program Files (x86)\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\VSTOR30 directory it has vstor30...
Can I invoke an option on a COM Add-in from a VBA macro in Word or Excel 2007? The COM Add-in was written using VSTO – it adds a custom ribbon tab with a number of options that I want to execute from a VBA macro. I can reference the add-in using Application.COMAddIns("MyAddinName") but I can’t find an option to invoke an option. I’ve a...
So I have a number of namedRanges in an excel worksheet. I would like to use these to fill in comboboxes on a user form in the same WorkBook. I have tried: cboMember.DataSource = Globals.Sheet1.MemberRange.Value No error is given but the combo is blank. Does anybody have any ideas? I'm trying to use VSTO for VS 2008 on an excel 200...
I'm having some issues deploying a visio addin. running the VSTO file works on my computer, but whenever i try and move it to any other user's computer it throws an error on deployment. I thought it might be a setting i'd set in the porject properties so i created an entirely new plugin project and set it to display a message box on star...
Hi, I am having some issues creating a setup file for my Outlook 2007 add-in. The issue is that the Add-In needs to have a registry entry that references the manifest (http://msdn.microsoft.com/en-us/library/bb386106.aspx). The project builds a manifest file that appears in my bin\debug folder. However, in my setup project, if I go a...
In our VSTO Word 2010 Addin, we are trying to insert a RichTextControl after a given other ContentControl. We have tried this: public ContentControl AddContentControl(WdContentControlType type, int position) { Paragraph paragraphBefore = null; if (position == 0) { if (WordDocument.Paragraphs.C...
Hello, I'm trying to update the information of a listObject hosted in a Workbook created by an Excel Addin (example Code1) with an commandline application. I've tried creating an instance of Excel and accessing at all the listObjects but GetVstoObject always returns null objects. I think is a security problem, but I don't know how to r...
I'm doing something similar to this, but wondering if there is an event somewhere that I'm missing Store DefaultStore { get { var defaultStore = mOutlookApp_Model.Session.DefaultStore; if ( defaultStore.StoreID == mDefaultStore.StoreID ) { // the default store we s...
What is the best way to access the cells that provide the data to a chart in Excel 2007 (using .Net). ...
Well I have browsed through Application events in Excel 2007 however I can't find any event generated on a cell click. I can't use a double click event at the moment due to application constraints. Is there a way I can create a custom click event and attach it to a sheet for generating a cell click event. ...
I want to modify the labels of the outlook conferencing add in... e.g. I want to change the "Schedule a live meeting" text to say "Schedule my meeting". is it possible using VSTO? or I can create only new add ins using VSTO and not customize the existing ones ?? (I am talking abt this conferencing add in: http://aspoc.net/archives/2008/...
Hi... I am making a Excel Addin in VS2010. The following code work fines if I make a winforms usercontrol private void ThisAddIn_Startup(object sender, System.EventArgs e) { var testControlView1 = new UserControl1(); var MyCustomPane = this.CustomTaskPanes.Add(testControlView, "Hello"); } However I would like to m...
Using Using VSTO 3.0 for Outlook 2007 I have my own item type derived from post called "IPM.Post.CustomType". However in the explorer window (the list of all items in a folder), the icon for my item is still the standard post item. How do I make my custom item show my custom icon instead of the standard icon in the explorer window? An...
When you are reading an email , you see in the from list the sender's name .. When you double click on the Sender's Name . You get a Outlook properties dialog box with Senders Information such as email , phone, location , address etc ., and in the dialog , i find a button labelled " Actions " with communicator icon in it. And the acti...
I have a custom class that is derived from Post called: "IPM.Post.CustomType" I have these items in the inbox and I'm trying to set the to field to show recipients. I've tried setting the following properties with no success. Any ideas? Or if I'm using a post item, will the to field always display as empty in Outlook? OutlookI...