Many of the parameters for interacting with the Office Object model in VSTO require object parameters that are passed by reference, even when the notional type of the parameter is an int or string. I suppose that this mechanism is used so that code can modify the parameter, although I can't figure out why these need to be passed as gen...
I want to check for the existence of a table with a given ID in a word document in C# (VS 2008) Visual Studio Tools for Office (version 3). Obviously I can iterate through the document's Tables collection and check every ID, but this seems inefficient; the document will end up having a few dozen tables after I'm done with it, and while ...
What would be the best way to expose certain functionality in a Dotnet VSTO Excel add-in to VBA, without requiring the user to be a local administrator (i.e. no COM registration, no HttpListener)? Would it be possible to use Microsoft Message Queues from VBA? ...
We are creating a Windows Form application (C# or VB.NET) that needs to reference an Office 2003 or Office 2007 COM object, depending on the version of office installed. What is the best way to handle this scenario and reference the correct COM object at runtime? ...
VBA solutions can vary widely in size. I would like to add user help documentation to all solutions but the level of effort to create and deploy the help needs to match the size of the solution. ...
I have Visual Studio setup with a VSTO word project, and when I hit run it runs fine. But, how do I setup a word document to use my code without having Visual Studio running? ...
It seems like deployment of VSTO code is very cumbersome. My use case is I need to enforce a certain content structure in word. Am I better of doing it all in VBA? ...
I'm using a series of ToolStrips in an Excel 2007 Actions Pane. I'm programatically adding buttons to each ToolStrip and then adding each ToolStrip to the actions pane. So far so good; my ToolStrips appear, with their associated ToolStripButtons. The problem comes with displaying the entire contents of the ToolStrip. I have ToolStrip....
I'm trying to open a Microsoft Excel file in a C# program using the 'excelApp.Workbooks.Open()' method. As it happens, if the format of the file is invalid, this method causes an error message box to be displayed. I, however, don't want that; I wish to handle this error gracefully in my own code. My question is, how do I do that? The ...
I have inherited an application built using the Microsoft Office Information Bridge Framework 1.6. My task is to make this application work with Office 2010. I am testing this on a computer with the Office 2010 beta installed, including .NET programmability support for all features. When I try to install IBF 1.6, the installer won't com...