I have created an outlook 2007 add-in project in vs2008, targeting .net 3.5, then migrated the project to vs2010. I have then published the project from vs2010 to a web site, and installed the add-in using click-once to a virtual machine running xp, .net 3.5 sp1, and outlook 2007. This all works great and I can see my add-in within outl...
I would like to create a excel Add in which creates some additional toolbars and Menu buttons. But I want this addin to load only when a specific workbook is opened. I dont want to load the Addin if anyother workbook is open. I would like to know what are the possible ways to solve this problem and what is the best approach to implement...
We have existing VS 2008 VSTO add-ins for Word 2003 and Excel 2003. We are unable to upgrade the Office version at this time. We have just tried to upgrade our solution to VS 2010 and it converts and compiles fine, but when building and running the add-in we receive a message saying that the required version of Office is not installed. ...
I'm working on a PowerPoint Add-In project. I'm trying to create a RibbonToggleButton in code-behind but I can't do it the way I thought, RibbonToggleButton toggleButton = new RibbonToggleButton(); Is it possible to create RibbonControls in code-behind and not the RibbonDesigner or RibbonXML? ...
Hi, I am attempting to hide some rows in an excel sheet using C#. but the line deleteRange.EntireRow.Hidden = true; is giving errors. The entire code of selecting the range and hiding the rows is given below string rowCnt = Convert.ToString(excelExportData.Tables["AllVersionDts"].Rows.Count + 8); string startCell = "A" + rowCnt; ...
I attach to Outlook.Explorer.SelectionChange event. Event handler makes a call to an assembly that retrieves some data from web services. After one call to that assembly my event handler is no longer called when SelectionChange occurs. Any ideas? This seems to be somehow related to the assembly itself, not what it is doing. Simply cre...
I have a form which spawns from an excel add-in written with VSTO. I would like the form to remain always above the excel spreadsheet, but still allow the user to interact with the sheet below it. The forms constructor includes this.TopLevel = true;, but the form still disappears behind the spreadsheet when I select a cell. Has anyon...
Hi I am running into a strange issue. I am developing a Outlook 2007 addin using Visual Studio 2010 with VSTO 3.0 and deployed using ClickOnce. I would like to check if there are any updates and if so prompt the user to restart outlook. However if I call ApplicationDeployment.CheckForDetailedUpdate or ApplicationDeployment.CheckForUp...
I am trying to call the Shared Add-in COM Registerd method from VBA. I am using .NET Framework 2 and doing the code as it is in the post http://blogs.msdn.com/b/andreww/archive/2007/01/15/vsto-add-ins-comaddins-and-requestcomaddinautomationservice.aspx But when i build the add-in i get the error 'RequestComAddInAutomationService()'...
I'm making a Word 2007 add-in with C# 4.0 in Visual Studio 2010. I need an Access 2007 database (a .accdb file) to be placed in the data directory by the clickonce installer. Unfortunately, the file is getting put elsewhere, so the application can't find it at runtime. I've seen various articles refer to using the Application Files dialo...
Env: VS 2010 | .net 3.5 | Outlook 2007 | VSTO 3 I have an outlook addin that adds a new message type (by inheriting from PostItem). I'd like to trigger the Outlook New Mail Toast/Alert when a new message comes in. Any ideas? ...
I am running into a strange issue. I am developing a Outlook 2007 addin using Visual Studio 2010 with VSTO 3.0 and deployed using ClickOnce. I would like to check if there are any updates and if so prompt the user to restart outlook. However if I call ApplicationDeployment.CheckForDetailedUpdate or ApplicationDeployment.CheckForUpdat...
I would like to be able to handle a Ctrl+x keypress event from within Excel (where x can be any defined key), such that the keypress will invoke a VSTO method on the worksheet which does some calculations and then sets a value in the currently selected cell. I haven't been able to find an event to handle this in VSTO (there seem to be m...
I am trying to programmatically copy a slide in a PowerPoint presentation, and paste it right after the original. My first thought was to get the index of the old slide, and add the copy at the desired new index, but I can't seem to find a straightforward way to retrieve that index. I expected to have something like Slides.IndexOf(Slide...
I am writing an Add-in for Powerpoint 2003 using Visual Studio 2008. I created it by selecting "New Project" in Visual Studio, then choosing the "PowerPoint 2003 Add-in" project template. I added a simple menu to PowerPoint which opens a simple windows-form. If I put a breakpoint into the Add-in code which creates the menu (code which...
Why don't I have an Apply as you work check box for "Automatic layout for inserted objects" in the AutoCorrect dialog box of of PowerPoint 2007? What I would really like is to turn it off\on programmatically. This code doesn't seem to do it: Globals.ThisAddIn.Application.AutoCorrect.DisplayAutoLayoutOptions = false; ...
Given a slide how can one figure out if all the slide layout placeholders are in use in PowerPoint? Can one prevent auto usage of a placeholder when adding a picture if that placeholder is not in use? ...
Hi, We are having a problem deploying a VSTO 2005 Second Edition Add-In and would appreciate any help with this. We previously successfully deployed this add-in onto a 32bit Windows 2003 terminal service environment. By default VSTO installs on a per-user basis. But we got around this limitation by creating a custom CASPOL script which...
I am developing add-in for excel and trying to read pivot tables but found no access to pivot tables from the worksheet , strangely pivot table can be reached from non add-in projects , I will be grateful if any one give me some info or code. ...
Hi, I'm trying to delete all charts that a linked to a specific PivotTable. My code is really simple, but I can't figure out how to test if the found chart's datasource is the given PivotTable's data. public void DeleteCharts(Worksheet mySheet, PivotTable myPT) { // Delete all charts foreach (ChartObject item in (C...