How to detect if filter(s) changed on a worksheet?
In excel workbook project, how could we detect if the filters on some worksheet are updated? ...
In excel workbook project, how could we detect if the filters on some worksheet are updated? ...
I am trying to save a ListObject from a .NET 3.5 Excel 2007 VSTO Workbook to a new sheet (done) and save that new sheet to a new workbook (done) without that workbook requiring the VSTO customization file (!!!!!). Has anyone had any luck with this? The only way I've had any success is just saving as a CSV file but that's not exactly ...
In my Outlook Add-in I want to be able to filter my default calendar for appointments that have the following criteria: all-day events = true reminders set = true I have figured out how to use DASL to search for those items, but how do I get the calendar view to show those filtered results? Here is the code I have so far: internal...
From within my VSTO word code. I need to get the path to where the document was created from(new Document). In this case its a sharepoint document library containing some folders. so the value im looking fore is somthing like http://myserver/mysite/documents/folder/ Ofcourse the location is different from time to time. Word has the val...
I am writing a VSTO addin for Word 2007. When the user selects File->New, (or selects it from the quick access toolbar) I need to display a custom form instead of the standard new document dialog. How do I do this? I don't see an application event I can handle and I can't seem to find the buttont to add an event handler too. ...
Hi all, I wonder if i can use the VSTO to create my custome message store 's mailitem. if yes, how do to it.. Thanks. ...
Is there an event I can register from my VSTO application that is fired when the theme of Word 2007 is changed? ...
I'm working on a Outlook 2007 AddIn using VSTO and one of the things my addin is supposed to do is to import contacts using web service. The algorithm for that is very simple: it asks web service for a list of identifiers of items that needs to be synchronized and then it fetches them and saves in Outlook. The problem happens when I ha...
I developed a new office 2007 addin using VS 2008 and VSTO. after this i go to Office->Excel Options->AddIns->COM AddIns and GO.. If i select the .dll which i ve created i get an error that " not a valid Office Add In." If i run it using the visual studio 2008 at my development machine, it works fine and i see the addin. I searched s...
I'm trying to develop an AddIn for Excel 2007, and have a solution full of code that executes and debugs just fine on other people's machines. When I try and Start Debugging in Visual Studio on my machine though, Excel gives me an error when it loads my AddIn: "An AddIn could not be found or located." I then click on the Details button...
When I generate a Class Diagram using VS2008, say for a C# file XYZ.cs - I get a Class Diagram detailing all the Fields,Properties,Methods and Nested Types. Is there a tool/utility, which will do the same for all the internal Class/Interface references I have used within this file. For eg. I have a Property of the type ABC in XYZ.cs .....
I am programming an Outlook addin. It's working fine, but now I want to add an event handler when a user makes a new task. For new contacts I am using this code and it's working. cnt.ItemAdd += new Microsoft.Office.Interop.Outlook.ItemsEvents_ItemAddEventHandler(this.cnt_ItemAdd); But for a new task this event is not firing. Thanks ...
I am planning to implement a small in-house document management system. It must have a web GUI for managing a remote folder structure stored in a database. In these folders are word documents stored (physically as blob in a database). Whenever a user clicks on a document link, a word binary is downloaded via browser and (hopefully) opene...
I'm trying to dynamically customize the built-in Ribbon Controls on an Office2007 ribbon by adding C# objects such as RibbonTab, RibbonGroup, RibbonControl to the Ribbon. I have been unsuccessfull in disabeling any existing built-in controls, however I can add my own group. Now i'm thinking that disabling or hiding existing ones not be...
is there any way other then filtering (Restrict) the items on Priavte field? I have an object of outlook Appointment/Task/Contact I want to check whether its marked as private or not ?? i'm using vsto / outlook 2003 / c#. ...
Hi, I have an annoying problem. I have a VSTO 2 plugin for Outlook 2003 (written with VS2005). I simply create 2 buttons that save email objects and work on emails. The problem is that the plugin, when just installed, is loaded by outlook and it works, but when I reboot the plugin is no more automatically loaded. I must re-enable it fro...
I'm working on a VSTO Outlook 2007 add-in that basically synchronizes Outlook data with web service. There are three types of synchronization that I want to have in the app: startup sync, manual sync and sync on shutdown. The first two as simple and are already done. However I have problems finding an appropriate event to fire to handle...
I'm taking some user data and adding it to a PowerPoint presentation using VSTO. To get the formatting to look right, though I need to be able to set the left margin of some of the text in the textbox. There will be an initial block of text followed by another, indented block. For example (underlines added to emphasize spacing): Lo...
Can someone enlight me about the version bindings between VSTO and the targeted office version? I am using VS2008 with VSTO 3.0 to build and deploy an addin for Outlook 2003. I am totally confused about what is required on the target machine: VSTO 2005 SE runtime or VSTO 3.0 runtime? .NET Framework 2.0 or 3.5 Primary Interop Assemb...
Hi, I have a Windows Installer project built for my VSTO add-in. However, I have to run one of my DLLs through an obfuscator at the end, but if I try to build the setup project with the modified DLL, it just rebuilds my original DLL and overwrites the modified one. Is there a way I can build the setup project and use my modified DLL? ...