I have a file added to my vsto project and I want to remove this file after publishing the project. This is because the file should only be avaliable for some customers, for others we want to remove the file. Is there a way to remove the file without resigning the manifest? ...
Hi, I am developing the addin for the outlook 2007 using VSTO. One of the function is to capture the send event, then force convert the email format to HTML and then insert a link to the bottom of the email message content. Following is my code to convert the email content to html format: mailItem.BodyFormat = OlBodyFormat.olFormatHTML...
We have a situation where we will have two VSTO Outlook add-ins which both start off with some common shared code, but the shared code will probably diverge over time. Ideally, we'd like to restructure the add-ins to factor out the common code into a separate shared dll, but for non-technical reasons this is not an option right now. What...
I have a VSTO spreadsheet, and have re-jigged the front end. I need to change some named ranges to reflect this. Couldn't see a good way of doing this, so I created other named ranges and pointed the code to refer to those instead. Is there a better way? ...
Background: I have an extensive set of specialized VBA macros used in Word for document formatting purposes. In Word 2003, these macros were activated from a customized toolbar. I have recently transitioned to Word 2007 and would like to be able to run these existing VBA macros from a new Word Ribbon created with VS 2010. I have created ...
Hi, I am working on a outlook 2003 addin(using VSTO), which launches a wpf window. I have added menus and tool bar on this form and assigned shortcut keys for them.The problem is that these shortcut keys are intercepted by the outlook resulting outlook default action. Example: Alt+f invokes file menu on outlook, instead of menu in wpf ...
I have written a managed AddIn for Outlook 2007, and am now tasked with porting it to 2003. The addin downloads DLLs into the local user profile folder, then reflectively loads them for execution. This all works just fine in Outlook 2003, even with Click-once deployment. The issue Im experiencing is that the AppDomain does not have Exec...
Hi, I'm new to Outlook add-in programming and not sure if this is possible: I want to display a pop-up form (or selection) and ask for user input at the time they click Send. Basically, whenever they send out an email (New or Reply), they will be asked to select a value in a dropdown box (list items from a SQL database, preferrably). B...
This is a very odd problem I've found. I have written and successsfully deployed a VSTO 3.0 Addin for Excel 2007. The problem is that the Tab for the Ribbon only shows up on NEW instances of Excel; the Tab doesn't display if I first open an already existing workbook. However, if I open a new instance of Excel, then open existing workbook...
I am building an app that has a toolbar for Excel 2003 (and earlier). The toolbar requires BMPs which means not transparencies. How does this work? Do I pick a grey or blue that matches most of my installations and let the rest suffer? Or do I set it to an arbitrary color and indicate that color as a transparency for the toolbar? I am...
We have a WinForms application where we have to use COM to interface with Excel and/or PowerPoint (I know, COM objects are a major hassle, and I'd like to not have to use them at all, but at least for now we have no choice). Some machines which will be running this app also have a custom VSTO COM Add-in installed within Excel and/or Pow...
Hello, I have requirements from our client where we basically have to 'parse' PDF files from various different sources. The solution we have come with, as 'phase 1' (as we have short time to market and will save them a huge amount of time) is 1) manually use Able2Extract application to pull out the columns you need from the PDF file, ...
My configuration is windows server 2003 (i'm logged in with admin privileges), office 2003, vtso runtime 2005 se. After installing my addin, all registry keys are in the correct locations and I have given fulltrust to my assembly using caspol.exe. My addin is a application level addin. When I run excel with regmon and filemon running I...
I'm writing a Outlook add-in that needs to access Outlook contacts. I have successfully obtained a list of local contacts but cant seem to find an example that will give me access to the list of shared contacts using VSTO. ...
I have generated a series of rows using C# and VSTO. I have basically loaded a couple of rows with data and have given each cell a NamedRange. My question is how would I, knowing the beginning row and end row index, traverse each cell and retrieve it's NamedRange. I've tried Excel.Range range = (Excel.Range)m_worksheet.Cells[x,y]; which ...
All, Cannot I have created a Word2007 Document Project and I'm trying to retrieve the content controls on the page via the GetVSTOObject method but it can not find the Microsoft.Office.Tools.Word.Extensions library after I have referenced the Microsoft.Office.Tools.Word.v9.dll as suggested on the MSDN site. I would greatly appreciate ...
I am planning to set the text in a content control, by using the Word.ContentControl.SetPlaceholderText() method: string myText = "Hello World!"; Word.ContentControl ctrl; ctrl.SetPlaceholderText((null, null, myText); myText = ctrl.PlaceholderText.Value; Can somebody let me know if there is any size limitation on the myText string? ...
Hi there, I'm trying to read the ActiveCell from within an Excel Add-in but not getting very far. Anyone any ideas? Excel.Window W = this.Application.ActiveWindow as Excel.Window; Excel.Range R = W.ActiveCell as Excel.Range; MessageBox.Show(R.Value2.ToString()); The Exception being thrown on the last line is: - Cannot obtain fiel...
I know that Outlook stores all mail in a .PST file. Is it possible to create a custom storage engine for outlook 2007? I would like to have the functionality similar to 'Personal folders', but have a new node of folders where everything is stored in a SQL Server database. Is Outlook extensible enough to allow swapping the internal s...
I am struggling to find a straight forward guide to creating office addins using VSTO and VB.net. Specifically I would like to know how to be able to create a addin/ dll which can either be referenced from VBA in the form:- Addin.method(argument) or Addin.property = X Or which would install its own custom toolbars/ ribbon interface to...