vsto

Excell 2007 cell auto-complete too slow for worksheets with 10,000 to 15,000 rows

I'm doing a Excel 2007 VSTO template where I load a worksheet with between 10.000 to 15.000 rows of data, and was counting on using the built-in excel cell auto-complete to speed future data entry. Nevertheless I noticed the auto-complete is very slow, it takes a couple of minutes for excel to, after starting to edit a cell, be able to ...

Listing Shared folders in Outlook AddIn

Hi, I'm working on outlook 2003 AddIn using VSTO. Is it possible to list all the folders that are shared with current user? OR to list the shared folders currently opened by user in outlook? ...

VSTO word add-in get docx as byte array.

I’m writing a plugin for word and would like to get the docx files as a byte array and send it to a web service. Can I do this? ...

Convert Word doc file to docx on a server without Word

I would like to use c# to convert a doc file to docx file. Can this be done without Word on a server? ...

monitoring a range of cells inside of excel 2007 with C#/VSTO

I have a row in excel I'd like to translate into an ObserveableCollection in C# for binding/event purposes, so all accessor classes know they're getting the latest data from the source excel sheet. How would this be done? Clarification: I'm using an excel add-in project, not a workbook project, so am not sure whether or not XMLMappedRan...

Is it possible to intercept Outlook Categories events?

Is it possible to intercept when user creates, renames or deletes a category in Outlook? ...

Access Document Stream from Office Ribbon Code

I am attempting to write an add-in for Microsoft Word 2007. I'd like to create a Ribbon Button that when clicked, gets a FileStream for the current or active document. I would assume that is possible with the Visual Studio Tools for Office. Does anyone have any sample code that would show how to do this? Let me know if you have any ques...

how to build outlook plug in

hello... i want to make plug in for outlook.i build an application in which i am creating contact,appointment n tasks.i want to see these contact,appointment n task in outlook and if i create any contact in outlook .i want to see outlook contact in application contacts... i had read many article but till now i don,t get any idea........

why I'm not able to debug in VSTO Addin?

If I select an extensibility addin of Excel, I'm able to debug my Add-In in Debug Mode with Excel, like _application.ActiveWorkbook.ActiveSheet.Count in Immediate window, but now I've moved to VSTO Excel 2003 Add-in, here I've goto following message while debugging, Cannot obtain fields or call methods on the instance of type ...

Unable to install a VSTO excel 2003 AddIn

I developped a VSTO SE Excel 2003 add in. When launching and debuging the add in from visual studio, it works well. But when I try to deploy it from my own install it never works. To sum up, here is my install process: the files are copied at the right location I register the addin: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Ad...

How to programmatically enable the "Options..." button in the MS Word Print Setup dialog

I'm trying to display the MS Word "Print Setup" dialog in a VSTO AddIn for Microsoft Word 2003. I can display the dialog box, but the options button at the bottom left corner of the dialog is always disabled as per the following screen capture. The relevant code for what I've done so far is: private void printSetup_Click(CommandBarBu...

Adding a Tab to the Outlook 2010 Ribbon?

I'm trying to create an Outlook 2010 addin that adds a new tab to the ribbon. I found out how I can add my groups to an existing tab by setting the OfficeId to "TabMail" or something built-in, but I don't want to modify existing tabs. I've now set the OfficeId that something of my own ("TabMyAddin"), but it doesn't show up in Outlook. I...

Adding a section to the To-Do bar in Outlook 2007/2010?

I would like to add a new section to the To-Do Bar in Outlook 2010 (or 2007). I found some code to create a new collapsible task pane and someone claiming you can't modify the To-Do bar, but I also found a product called Add-In Express that claims it can do it (although at $349 it's not worth it for a one-off project). Is is possible to...

How to customize save behaviour in Word using VSTO

Fundamental question on how to get the bits to work together: I've not used VSTO before and after 4 hrs of searching I've decided to ask! I want to create a simple AddIn for word that will execute when the user saves ANY document. I thought all I would need to do would be to create an AddIn in VisualStudio 2008, and put my code in the ...

Avoid Microsoft Office SDK installation as part of my app

Hi All, I have created a VSTO visual studio application in Visual Studio 2008. It's working fine and I wanted to create a installer for the same using Publish option. Now, I see that it creates the installer with Microsoft office SDK (194 MB) part of the installer. i don't want the client or my customer to install such a large componen...

outlook plugin to catch compose mail events

I got an adjoining formregion in the compose mail form and i dont find the way to intercepts the form events like the drag and dropping of a file inside the message or the insertion of a text. NB: Ms has forbidden the complete replacement of the compose mail form so i cannot re-write the form has i want ...

VSTO, Outlook.exe.config, and <supportedRuntime>

I've created a VSTO 2.0 SE add-in for Outlook 2007. Usually, it installs no problem on end-users' machines, but sometimes they have an outlook.exe.config file next to Outlook.exe which specifies that only .NET 1.0 or 1.1 is allowed to load. For example: <?xml version="1.0" encoding="utf-8"?> <configuration> <startup> <supportedR...

How can I get the Range of filtered rows using Excel Interop?

I'm using Excel Interop assemblies for my project, if I want to use auto filter with then thats possible using sheet.UsedRange.AutoFilter(1,SheetNames[1],Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd,oMissing,false) but how can I get the filtered rows ?? can anyone have idea?? ...

Detecting when a Windows Form control on an VSTO Excel worksheet becomes deactivated

I'm building an Excel 2003 VSTO workbook level customization and have placed windows forms buttons and comboboxes on the worksheets. I also have a freeze pane set on the sheet that divides the sheet into 4 sections. 1 2 3 4 The controls I place on a pane that can be scrolled, such as 2, would become deactivated (turn into the image plac...

excel programming

I am new to Excel programming. What are the differences among UDF, Macro, Add-in, Automation Add-in, XLL, VSTO which one I should use and under some circumstances? Thanks! ...