I have a Visio Addin written in C# that add a custom CommandBar to Visio. The MSDN documentation mentions that the Visible property of the CommandBar is False by default. However, my CommandBar is being displayed by default when my Addin starts (even If I force the visibility to False). What is strange, is that it happens only at startu...
using vsto, C# fx 3.5, how to check Excel Workbook or sheet is password protected or not? ...
Hi, I am writing a small Excel VSTO application. In one of the windows the user writes a full name of a recipient and I want to resolve the recipient's exchange address. I got it to resolve names fine - but when you use a name that is used by more than one person the resolve fails. When you do this in outlook a dialogue shows up which a...
I am running into an issue with Excel 2007 via VSTO 3.0. In my project, I need to shuffle columns around occasionally. Normally, this works fine but I have recently found that an issue arises when the data is filtered and the fitlered data is non-contiguous. For example, using this data set: Ohio Eastern Kentucky Eastern Ill...
Hi there, I have some code that those: void mActiveSheet_Change(Microsoft.Office.Interop.Excel.Range Target) { if (Target.Cells.Formula.ToString().StartsWith("=FR(")) .... } So whenever someone uses my custom function "=FR" I can handle it. That's fine but while the formula value for that cell ...
Hello, I developed a plugin for outlook 2007 that adds a button to the office ribbon. I wanted to know if there is any possibility (programmatically) to not show the popup message when hoovering over the button with the mouse pointer. When I hover over the button, a little popup (tooltip) with the following text is displayed: MyAddinN...
I was wondering if there is someway to embed a Flash Shockwave Object or .SWF file in PowerPoint (Presentation) 2007 and higher version, i.e. inside the ".pptx" format. By embed I mean when I save the presentation,close it . i wont be needing the the .swf file again. That way I can share the presentations with others. If I use this lin...
Hi, as a workaround for the Locale bug in Office Interop I wanted to use VSTO but if I call app.ActiveWorkbook.GetVstoObject() then it returns nothing. I'm working from a .NET 2.0 Visual Basic Application project. This is not an add in or a special VSTO project. I have added the required Imports and References. Dim app As New Excel.A...
When VSTO code creates a list object and applies a table style in Excel 2007, the Table Tools/Design tab is activated automatically. When the user then selects a non-table cell, the Home tab is activated by default. Is there a way to either suppress this behavior or reset the active tab to the custom tab that started the action? What ...
Basically I would like to keep the existing format of an Excel cell. If I use ActiveCell.Value2 = "new value"; The ActiveCell displays "new value" but loses the user defined formatting ( say red font, blue background), all formatting values goes back to Excel default format values. Note: If you replace a cell value using Excel, Excel k...
I have no background in reporting tools. I'd like to generate some statistical tables and plots. Is VSTO(Visual Studio Tools for Office) good enough for this task? What's the main difference VSTO tool chains and other reporting tools, like crystal-reporting. ...
I need to copy text from one PowerPoint presentation to another. However, I have problems copying special symbols, such as smileys, which appear in the target presentation as empty boxes. Looking at the Open XML file in the original presentation, I can see that the Run containing the smiley has a "SymbolFont" attribute: < a:sym typeface...
Hi! I'm using VSTO to create an Excel Add-on. This add-on retrieves and display alot of data from a sql-server. This works great, but later on I plan to access some of the data inside excel and modify it in some ways. My problem is that I need a way of classify cells that I want to modify. Is there any way to add meta-data to a cell to ...
We're currently using a thing from SoftArtisans to generate Excel spreadsheets from data the mainframe FTPs down to our document server. The doc server has the .Net frameworks through 3.5 on it, as does my development box. The difference is my machine has Office 2007 as well. So, I built a service this morning with a filewatcher usi...
I'm quite confused with what are the necessary tools for VSTO develpment. Specifically I want to manipulate Excel 2003/2007 documents programmatically. I did quite a lot of VBA before, if you want to relate any answer to that. Few questions I have about VSTO: Can I use Visual Studio 2008 Express Edition C#/C++ for this? Do I need to h...
Hi, I have a very simple Excel Addin build it in Visual Studio 2008 for Excel 2003, which creates a toolbar with some buttons. When I debug it, with System Format set to "English (United States)" it works great, without problems. However, this addin is going to be used with System Format set to "French (France)" too, and when I try to...
Hi , I am creating a pst file in Outlook using C#, and Addin express. The new pst file ("My Inbox") should have Inbox,Sent Items, Outbox. Outlook.Folders olFolders = olNamespace.Folders; foreach (Outlook.MAPIFolder olTmpFolder in (IEnumerable) olFolders) { if(olTmpFolder.Name == "My Inbox") { ...
with the push to leverage visual studio and dotnet with office based solutions, especially excel, where is the best article or information on how having office sheet with additional binaries and assemblies is sharable. Do this external code get packaged with the spreadsheet what if people start emailing the spreadsheet around. Is th...
I am developping a C# programm which creates a PowerPoint presentation. However, I am running into a problem with the following instruction: Presentation pres = pres_set.Open(path, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoTrue); This instruction w...
I am using VSTO to fill data into a table in a Microsoft Word 2007 template. The amount of data varies and filling many pages (+50) takes a lot of time. The code I use to create a table: Word.Table table = doc.Tables.Add(tablePosition, numberOfRows, 8, ...