Do you have a good solution for keeping a 'Please wait' winform 'painted' while an application is performing a long running task ? I've tried using form.refresh() on each step, but there are a few long running queries that take place, which means that this isn't frequent enough. Basically this SO Question but, on C# in Excel through VS...
Hi, I've created a vsto 3.0 outlook 2007 plugin with visual studio 2008 (so I guess that I dont need to make a com shim because of the new security system). The assembly is signed and it gets installed and loaded. It works well for a few days but, suddenly, stops loading and I get this exception on the event viewer thrown by VSTOR3.0: V...
There appear to be a number of suggestions to do this, non of which appear to work. Effectively, I'm wanting to change a text value in an Excel sheet to a number (this is a cell that has been set as a number stored as text, and has a green diamond next to it). This webpage details how to resolve the issue in Excel, through the UI, and ...
Hi all, The scenario: I have a VSTO template which is installed to SharePoint. Now when i create a workbook from SharePoint (by clicking New->My Template) from the List i run my code on the ThisWorkbook_Startup event. Inside this event i need to get hold of the list-url which is "calling" the action, as i need the list-name. In W...
I'm experiencing a bit weird problem with VSTO Outlook add-in I'm developing. It works fine on a bunch of machines but in one it throws an InvalidCastException and cannot find the reason why. I've checked that all prerequisites are installed on this machine (the installer doest it by itself but I also checked that manually) and everythin...
I am using c# to write an Outlook 2007 add-in to store emails in a SQL Server 2005 database. I would like to be able to store the entire .msg file in a varbinary(MAX) field. Is there a way to do this without having to use the Outlook MailItem's SaveAs() method to save to a temp file and then read the file back in? I will need to transfer...
We have an issue with an Outlook 2007 AddIn (created on a Windows 7 development machine with Visual Studio 2008/VSTO). It installs with the MSI installer on these machines: - the development machine - a Windows XP machine Install initially succeeded on a Vista machine, but after installing an updated version of the AddIn, it gets disa...
I've written this little MS Outlook 2003 VSTO Add-In using C# and Visual Studio 2008. It is meant to check each Mail Item being sent for the word "attach" in the body and if found, then check the number of attachments. If that number is zero, then ask the user if they really mean to send the message. It's supposed to work like the Gmail ...
ThisAddIn class created with new Outlook VSTO C# project has a Application property that you can use to among other things get access to Outlook folders and items. The problem is that you can easily use it when you're inside of ThisAddIn class but there's no easy access to it from other classes in the project. This is because it's an ins...
Hi, I'm working in a ribbon project for Excel 2007, using Visual Studio 2008 and VSTO, I'm trying to make my ribbon's groups collapse into galleries when I resize the Excel window, this is a functionality that the other tabs in the ribbon have (the tabs that come with Excel). At first, I thought this wouldn't be that much difficult, I i...
I've written a little C# VSTO add-in for Outlook 2003 that reads the body of emails as they are being sent, looking for certain words. It's working right now to do this: if (currentItem.Body.Contains("text to search for")) ... but that checks the entire email body, not just the new message being sent. Is there anyway to have Outlook...
Hi All, I'm working on VSTO Excel 2007 AddIn in C#. I need to call Formula Dialog and than to fetch the formula string from that dialog. Problem is that dialog doesn't offer something like dialog.FormulaText but instead inserts formula in ActiveCell. So code like this: var dlg = this.Application.Dialogs[Microsoft.Office.Interop.Excel...
I am writing an add-in for Outlook using C#. Is there are way to programmatically expand and collapse folders in the Outlook 2007 folders navigation pane? Also, is there an event fired when a folder is expanded? ...
Does VSTO 3.0 (using Visual Studio 2008) support both Office 2003 and Office 2007 installed side-by-side on a single development computer so that both Office 2003 and Office 2007 can be targeted (in separate solutions)? I have seen conflicting information about this. NO: http://msdn.microsoft.com/en-us/library/bb398242.aspx Visual ...
hello, I have written a vsto addin with VS 2005 for excel 2007. This addin is able to add XLL files to addin list. That works fine in excel 2007 but in excel 2010, i have "Attempt to read or write protected memory" on this call : this.Application.AddIns.Add(aAddInFullPath, Missing.Value); I have checked that aAddInFullPath is ok...
Hi, I have created a Word Addin and created the MSI package to distribute it. Using the information found in http://msdn.microsoft.com/en-us/library/cc563937.aspx ... I have tested the Setup.exe and the Addin installs correctly. The issue is when deploying the Addin over our network our system admin needs the file in an MSI rather th...
I'm working on Outlook 2003 AddIn using VSTO.Is there a way to Get the Mailbox Name OR NTUserName of the user. ...
How can an Outlook add-in set a MAPI property (for example, the body content) on a message, but only have it saved in the local cache (and not sent back to the exchange server)? I've seen this done with a few encryption add-ins. I'm open to using pretty much any API that could do the trick. Thanks! ...
I have a use case where some text has to be processed in the entire word content. This includes all content including direct text, text inside tables and inside shapes at all levels. Is there any way to enumerate contents and replace them as well in both 2003 and 2007 versions using VSTO? ...
I'm having trouble getting a vsto project to work. It's a simple Word 2007 addin application that adds a smarttag identifier. here's the error: ************** Exception Text ************** System.ObjectDisposedException: Cannot access a disposed object. at Microsoft.Office.Tools.SmartTagCollection.BeginInit() at WordInWord.ThisA...