HI, I'm trying to make some code color a PivotTable. It works just fine coloring the cells it's supposed to, but if I refresh the table, all the colors disappear, as if the colors haven't been properly attached to the PivotTable. I have the following code (this is a snip from a larger code): myPivotTable.PivotSelect("'" + item["Name"]....
I have added user property in a mail folder, let's call it UserProperty01. Some of the folder items have this property, some don't. I need to show in the folder's view if that property is set or not, so I added another property called UserProperty01Present, and I set it to true when I set the original property and false when I deleted it...
I have a YesNo column in a folder, and I added it to the folder view; it appears as a checked or unchecked checkbox. I've been asked to replace it with a green or red circle. Is this possible? Thank you for your time. ...
I'm working on outlook 2007 VSTO Addin.I have added a Ribbon with a button. I am trying to raise an event on button click.On NewInspector event of Application.Inspectors collection I should be able to hook on to this ribbon event in the Presenter. The questions is how to get hold of Ribbon of Inspector opened. I tried Globals.Ribbons.My...
I want to create a custom ribbon button within Outlook 2007 using Visual Studio 2008 Standard, but am unsure how to proceed. Most of the resources I've found mention VS 2008 Pro, and this SO answer mentions that VSTO is not even included in Standard. Is creating custom ribbon buttons possible using Visual Studio 2008 Standard? If so, ...
We deployed a VSTO addin for outlook 2003. After installing the addin one of the user's outlook crashes when a contact is opened, i.e, when ItemProperties of the contact are read.Some theses properties are read using MAPI.There is no exception being logged even though we have try/catch and logging in all methods. The event log has follo...
Can anyone provide some information on how to programmatically translate HRESULT (http://en.wikipedia.org/wiki/HRESULT) values to a human-readable message? I know that the utility ERR.EXE does this, but my app needs to display some meaningful message to my users rather than a cryptic 0x800A03EC. ...
Hi! I have Office 2007 VSTO add-in, it uses ribbon XML, and so on. When the Office is first started after the reboot, it takes significantly longer time, than when it is started for the second time. The add-in is registered as vstolocal and trusted using VSTO inclusion list during installation. As I understand, this avoids installing it...
Hi All I want to develop and automate Office software like 'Microsoft Excel 2007' And 'Microsoft Word 2007'. But I do not know how to use VBA or use C#/.Net Framework to do so. What are the benefits of using VBA vs .Net framework? Which one should I focus on learning? ...
I'm currently using Visual Studio 2010 Professional, and noticed the ability to create Word 2007 and Word 2010 documents as add-ins with C#. What I'm looking to do is fill in a report-type document with information in my C# application, and then output the final .docx. Is this possible using this feature, and how do I go about doing it?...
I've developed an office VSTO3 application for MS Office 2007. Now I'm in a process of porting it for Office 2010. I've created a new project targeted for 2010 and mostly just copy-pasting the code from 2007 project. I've moved as much code as I can to external libraries but still there's quite much code in main project. I was wonderi...
I am attempting to put together a Word application using VSTO that, amongst other things would contain bookmarks that, when clicked, display information in a custom task pane. I would like to be able to export this document into XML, but if you simply save it in this format, the "pop up" behaviour is lost. I am intending to write an "ex...
I have a Web application which will be deployed to Windows Azure and I'm looking for alternatives to generate Excel spreadsheets. Can I use VSTO to programatically generate an Excel spreadsheet in a Web Role running on Windows Azure?... If yes, how should I deploy the application to Windows Azure? What assemblies should I include? Than...
Hi, I am new to VSTO programming. I have created a basic addin for Outlook 2007 that monitors a folder containing XML text files which it opens and then sends them as an email, then deletes them. this all works fine. I want the user to be able to configure certain settings for the way the addin/program will operate, such as the folder t...
Hi, I have to find/replace text from a word document. It works fine for plain text spread through the document, however when the text is in a textbox, the standard find/replace approach doesn't reach it. I found a vba solution, however since I am working in C#, I would like to find a solution in C#. The word document is in 2007 form...
Ok, let me explain it little bit better. Here is one example how to create formula/functions http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/273127.aspx?PageIndex=1#comments I implemented something like that, I even added values in registry, so that this Automation AddIn doesn't have to be added manually in Excel, but automatic...
Hi everyone, We have an application that is built with Excel as the front end using the Office object model. We were using a C++ shim to load it as a COM add in for Excel 2003, but I've updated it to use the latest VSTO for Excel 2007. I've also been using VS 2010 for the latest version. The problem is that everything works great on m...
I have a problem with Visual Studio 2010 and Outlook Addin 2010 project (.NET 4 target). I've added a form region to my project and then I've changed Localizable property to true. Now if I close my form region and reopen it, I'm getting this VS error page: To prevent possible data loss before loading the designer, the following errors ...
Using VSTO or some related technology, is it possible to programmatically embed a button in a cell of an Excel worksheet, and configure it to call a C# function when it is clicked? How? Thanks. ...
Hello, I'm currently considering to rewrite an Excel 2003 workbook that has VBA code in it to VSTO. This workbook contains multiple sheets. Each site has a visible button at the top of sheet. When the user clicks the button, it uses the data from some named cells as a parameter to retrieve data from a database and populate several tabl...