Binding Repeating Nodes to a Database in Word

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - VS 2008
  - Windows Live
  - VC++
  - Smart Device
  - SQL Server
  - VS Express
  - Windows Forms
  - Windows Vista
  - IE
  - Visual Studio
  - Architecture
  - Office
  - Dotnet
  - ISV
  - Game
  - VFP
  - Visual C#
  - SharePoint
  - VB

- Previous
  - 1
    - Passing parameters programmatically from VB.NET to Word Application.Run command Chris Severin wrote: Thanks for getting back to me. And thanks for the great idea! I don't know why, but it never occurred to me to pass an array as a single parameter. My train of thought got stuck on a single track, I guess. Anyway, I gave it a try and it works great! The only modification I made so I could run the macro programmatically from my VB.NET application was to add a second parameter to hold the number of elements in the array so I can control looping through the array elements inside the macro VBA code. Chris, take a look at the Lbound and UBound functions (they come from the shared Office VB library, not Word's object model). You should be able to use these to get the number of elements in the array in VBA code. No need to pass a static number :-) Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 2
    - Publish custom forms programmatically I have a requirement where I need to Publish the custom forms (.oft) programmatically. Any idea how to achieve this Code snippet would help. Thanks, Rama Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 3
    - Outlook Message Icon I have seen a few applications who place messages in outlook inbox with a more or less costum system icon instead of the normal mail/task/calendar icons. Do any know on how to change those icons I am looking for a way to insert system messages from an application into Outlook, but need a way to change the icon at the same time. Cheers, Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 4
    - Trap save event in application level add-ins Thanks Cindy, esp for the heads up on AutoSave... think I will try another approach. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 5
    - Word document author Yes. VSTO wraps the property in its own Document class, but it's part of the Word object model. Code Snippet Sub DisplayAuthor() Dim author As String author = ActiveDocument.BuiltInDocumentProperties(wdPropertyAuthor) MsgBox "This document was authored by " & author & "." End Sub -Phil Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 6
    - DOCVARIABLES and specials characteres Hi all, I'm using DOCVARIABLES (Word.Variables) and I need to set name of those variables using spaces. It seems Word won't insert variables spaces. In place, it display something like "Error, no variable giving by the document" ("Erreur ! Aucune variable de document fournie" in french). If someone has a idea to do this... Thanks in advance, TSalm Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 7
    - Apply decmial numbers to Excel Ranges This is the kind of question that's best asked in the more specialized excel.programming newsgroup. Or at least in a separate message thread, but... The way I understand the Excel Help files is that you need to specify the range, then set the NumberFormat property. This is the equivalent of using the Format/Cell dialog box. Apparently, NumberFormatLocal will base on the underlying NumberFormat, but use the Windows settings for the locale. NumberFormat should be interpreted literally by Excel. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 8
    - Delete Outlook MailItem? Having similar problems but only with 2007 outlook..... 2003 this code works 2007 it throws an exception.. Message cannot delete ..... Try GetCurrentMailItem.Delete() Catch ex As Exception MsgBox( "About To Delete Emails -" & ex.Message) End Try Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 9
    - NEW Fix for VSTO SE Addins for Office 2003 and Vista This update improves Windows Vista support for VSTO 2005 SE. This support enables you to run and to debug add-ins for Microsoft Office 2003 Professional by using VSTO 2005 SE in Windows Vista. Just wonderful,It sounds great! I'll have to try that. Cat site directory Cat breeds Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 10
    - COM addin adds over 10 seconds to Microsoft Word startup time Moving to the VSTO forum, the VS Extensibility forum is for programming the VS extensibility model. Craig Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 11
    - Detaching VSTO customization The custom document properties you heard about are _AssemblyName and _AssemblyLocation. These properties identify that the document has a VSTO customization associated with it. For more information, see http://msdn2.microsoft.com/en-us/library/ds87aeyf(VS.80).aspx . While it is possible to disassociate the VSTO customization from the document by removing these custom document properties, this isn't generally recommended, because artifacts of the VSTO customization (namely, the data cache and the runtime storage control) will remain in the document itself. I'm curious about the "The supplied application manifest is not valid." message you received. Which of the two procedures in the topic http://msdn2.microsoft.com/en-us/library/8fza57cs(VS.80).aspx (that is, calling one of the RemoveCustomization methods, or calling ServerDocument.AppManifest.Clear ) did you try that resulted in this error McLean Schofield Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 12
    - API to retrieve Address from outlook address book? In versions before Outlook 2007, Outlook does not directly expose the right-click context menu in its CommandBars collection. You will, however, see a new right-click command is when the item selected is using a custom form that includes one or more custom actions. You can also add a custom action without using a custom form, as demonstrated at http://www.outlookcode.com/codedetail.aspx id=526 Richard Kagerer has posted a code sample at http://www.outlookcode.com/codedetail.aspx id=314 that shows how you might trick Outlook into exposing the context menu through Explorer.CommandBars. The C++ sample add-in at http://www.codeproject.com/atl/outlook2k3addin.asp also shows a technique for working with the context menu. Outlook 2007 provides Application-level events for the most commonly used context menus. In none of these cases, however, are context menus in the address book exposed. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 13
    - Is it possible?? Hi, How could I uninstall my add-in that created button MyButton" in the outlook 2003 toolbar from MyButton event clicked Is it possible to reset toolbar I did in vs.net 2003 code: Code Snippet OnToolbarButtonClick(CommandBarButton cmdBarbutton,ref bool cancel) { Microsoft.Office.Interop.Outlook.Application applicationObject.ActiveExplorer().CommandBars["Standard"].Reset(); ///I want to add uninstall this add-in.. } Thanking you in anticipation! Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 14
    - Adding InfoPath Form as Mail Attachment Thank you for your answers. In fact my goal was to open an Outlook client to allow the user to choose the receiver with the InfoPath form in attachment. So using the InfoPath feature implies you already know who you want to send the mail. That's why I tried with the Outlook perspective, but there are too many security problems, only if you just want to save the form. The solution I finally implemented uses the mailenvelope object : function CTRL1_5::OnClick(eventObj) { var mail = XDocument.View.Window.MailEnvelope; mail.Subject = getNodeValue(xmlTitle); mail.Visible = true; } This opens an Outlook interface and allows the user to change the "To" field. The form is also visible in the mail. The limitation here is that there are only 4 or 5 properties for this object, and you can't change the name of the attachment for example. Kype Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 15
    - Deployed Excel Add-in doesn't load The below I pasted from my upload on http://www.microsoft.com/office/community/en-us/default.mspx dg=microsoft.public.excel.programming&mid=1d13e6bc-4cc9-41ae-9744-2b32bc20a267 As this is the first VSTO-Office Add-in I try to deploy I haven't a clue why things doesn't work. The Add-In does install into the directory I expected, but simply doesn't load into Excel! (I see now a thread "Mysterious Add-in load issue" popping up, so sorry if this duplicates that thread) ADDITION I tried the suggested http://download.microsoft.com/download/b/6/7/b6711d3b-b509-4567-8599-98bf3473310f/vs2005-kb908002-enu-x86.exe solution mentioned in that thread however at this moment things seems to remain the same as it was! (perhaps since I'm using office 2007 in stead of 2003! , I'll experiment somewhat further with this!!!!) ======== FURTHER EXPERIENCE After restart of my developmentpc the Excel Add-in worked, however the Add-in setup Bolts crying the need for: KB908002\extensibilityMSM.msi KB908002\lockbackRegKey.msi KB908002\office2003-kb907417sfxcab-ENU.exe Read the need to add a seperate directory to the location of the setup, after this the setup worked on the targeted USER-machine However attempts to load the Add-in still gave the loading problem! ======= APOLOGIES with appologies for this scrappy contribution, it turned out that the above version that "worked" was the compiled, which had to be manually removed. after done thus and reinstall the add-in, also on this development machine the add-in DID NOT load. So back to where I was at the situation described below, on both development and user pc's. END ADDITION I wrote an excel 2007 add-in with C# using VSTO and VS 2005. The add in works fine when started from VS 2005 so I sought to deploy. The manifest reads: <assembly xmlns="urn chemas-microsoft-com:asm.v1" xmlns:asmv2="urn chemas-microsoft-com:asm.v2" manifestVersion="1.0"> <assemblyIdentity name="WinPrefabExcelPane.dll" version="1.0.0.0" /> <asmv2:entryPoint name="Startup" dependencyName="dependency0"> <asmv2:clrClassInvocation class="WinPrefabExcelPane.ThisAddIn" /> </asmv2:entryPoint> <asmv2 ependency asmv2:name="dependency0"> <asmv2 ependentAssembly> <assemblyIdentity name="WinPrefabExcelPane" version="1.0.0.0" publicKeyToken="67511199162933c1" /> </asmv2 ependentAssembly> <asmv2:installFrom codebase="WinPrefabExcelPane.dll" /> </asmv2 ependency> </assembly> Trying to load this installed version however I get after trying to load this "COM Add-in" the message: Load Behaviour: Not loaded. A runtime error occurred during the loading of the Com Add-in. this is the first Add-in I try to deploy in this manner, so I currently have no clue of what is wrong here. The location of the manifest is as expected, but something seems to be missing. As said, starting from VS the add-in works fine. Please help. Problem doesn't seem to be whether or not VS8 is installed. also on this development machine, the installed version of my Excell 2007 add-in doesn't work. When started from my main program from where my users are supposed to start Excel from. Using the installed add-in when program starts from VS8 is an option I might look into. Strangly enough, starting the "mainprogram" from the release directory wherein it is compiled and starting Excell the Add-in loads ! However this seems to be the compiled version of the Add-in and not the installed version! I haven't a clue where the programs (Excell ( )) would obtain the information to start the compiled Add-in! Just some more information on the problem. VSTO / Office people might have some idea. I'm a programmer in a production environment and the system should be up and running asap, currently no user (without VS8) can even test the system! curious oddity. Excell 2007 add-ins seem to be centering around .manifest files. the "COM Add-in" interface of Excel 2007 one can Remove the installed (it seems) Add-in however for some peculiar reason the Add option does not offer the option to reinstall a .manifest file (exe and dll are opted to search for). The only way to reobtain the .manifest in the listed options is to reinstall, which as said doesn't work. So there is no way to try the version in my compiled directory this way. Copying two .pdb files (from the compile release directory) into the install-directory doesn't seem to help, didn't think so but heh at this point I'll try anything. Information anywhere about these .manifest files is curiously low, save some listings in the two books. (I reckon since things ain't working as they should!) Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 16
    - Outlook 2007 Web Browsing Add-in Hello Ryan, here is a sample codesnippet. There you can see a FolderSwitch event of the explorer. Also there is a samlpe how to manage multiple Explorers and Inspectors. Hope this will give you a start. greets, Helmut. P.S. sometimes VB is better - sometimes C# my personal favourite is C# Code Snippet using System; using System.Windows.Forms; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Outlook = Microsoft.Office.Interop.Outlook; using Office = Microsoft.Office.Core; using System.Collections; using System.Diagnostics; using System.Reflection; namespace ExplorerTest { public partial class ThisAddIn { /// <summary> /// This generic collection holds a reference to our open explorers. /// </summary> Hashtable _WrappedExplorers; /// <summary> /// This variable must be used to keep a reference to the Application Explorers collection. /// Required to get informed about new Explorers. /// </summary> Outlook. Explorers _Explorers; Hashtable _WrappedInspectors; Outlook. Inspectors _Inspectors; private void ThisAddIn_Startup( object sender, System. EventArgs e) { // initialize the List that will keep an eye on our active Outlook Explorers. _WrappedExplorers = new Hashtable (10); // Do we have already some explorers after startup _Explorers = Application.Explorers; for ( int i = _Explorers.Count; i >= 1; i--) { // Wrap the Explorer and do some usefull with it WrapExplorer(_Explorers[i]); } // remember the Outlook.Explorers (GC) _Explorers = this .Application.Explorers; // register for new Explorer event. _Explorers.NewExplorer += new Outlook. ExplorersEvents_NewExplorerEventHandler (Explorers_NewExplorer); // remember the Outlook.Inspectors object (GC) _Inspectors = this .Application.Inspectors; // Create a Hashtable that holds a reference to the wrapped Inspectors _WrappedInspectors = new Hashtable (); // register for the new inspector event _Inspectors.NewInspector += new Outlook. InspectorsEvents_NewInspectorEventHandler (_Inspectors_NewInspector); } private void ThisAddIn_Shutdown( object sender, System. EventArgs e) { // remove all references to the wrapped Inspectors. _WrappedInspectors.Clear(); _Inspectors = null ; // remove all references to the wrapped Explorers. _WrappedExplorers.Clear(); _Explorers = null ; } /// <summary> /// The new Inspector event occures whenever an outlook inspector was opened. /// </summary> /// <param name="Inspector"> The outlook inspector object. </param> void _Inspectors_NewInspector(Outlook. Inspector Inspector) { try { Outlook. Inspector inspector = Inspector; WrapInspector(inspector); } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); } } /// <summary> /// This method wraps an Outlook Inspector object and registers for the InspectorClosed event. /// </summary> /// <param name="Inspector"> The Outlook Inspector Object. </param> void WrapInspector(Outlook. Inspector Inspector) { // Wrap the Explorer and do some usefull with it InspectorWrapper wrappedInspector = new InspectorWrapper (Inspector); // register for the closed event, so we can releas it from memory wrappedInspector.InspectorClosed += new InspectorClosedDelegate (UnwrapInspector); _WrappedInspectors.Add(wrappedInspector.ID, wrappedInspector); } /// <summary> /// This method should be called when a wrapped Outlook Inspector has been closed. /// </summary> /// <param name="explorerId"> The unique ID of the closed explorer. </param> void UnwrapInspector( Guid explorerId) { // if we have a reference to this explorer we can release it now if (_WrappedInspectors.ContainsKey(explorerId)) { _WrappedInspectors.Remove(explorerId); GC .Collect(); GC .WaitForPendingFinalizers(); } } /// <summary> /// This event occures en a new outlook explorer has been opened. /// </summary> /// <param name="Explorer"> The opened Outlook Explorer object. </param> void Explorers_NewExplorer(Outlook. Explorer Explorer) { // Wrap the Explorer and do some usefull with it Outlook. Explorer activeExplorer = Application.ActiveExplorer(); WrapExplorer(activeExplorer); } /// <summary> /// This method wraps an Outlook Explorer object and registers for the ExplorerClosed event. /// </summary> /// <param name="Explorer"> The Outlook Explorer Object. </param> void WrapExplorer(Outlook. Explorer Explorer) { // Wrap the Explorer and do some usefull with it ExplorerWrapper wrappedExplorer = new ExplorerWrapper (Explorer); // register for the closed event, so we can releas it from memory wrappedExplorer.ExplorerClosed += new ExplorerClosedDelegate (UnwrapExplorer); _WrappedExplorers.Add(wrappedExplorer.ID, wrappedExplorer); } /// <summary> /// This method should be called when a wrapped Outlook Explorer has been closed. /// </summary> /// <param name="explorerId"> The unique ID of the closed explorer. </param> void UnwrapExplorer( Guid explorerId) { // if we have a reference to this explorer we can release it now if (_WrappedExplorers.ContainsKey(explorerId)) { _WrappedExplorers.Remove(explorerId); } } #region VSTO generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InternalStartup() { this .Startup += new System. EventHandler (ThisAddIn_Startup); this .Shutdown += new System. EventHandler (ThisAddIn_Shutdown); } #endregion } #region delegates used handling explorers /// <summary> /// A delegate used to inform the application that an explorer has been closed. /// </summary> /// <param name="explorerId"> The unique ID of the Explorer that has been closed. </param> internal delegate void ExplorerClosedDelegate ( Guid explorerId); #endregion #region ExplorerWrapper /// <summary> /// The ExplorerWrapper is used to wrap around an Outlook Explorer. /// It keeps a reference to the Explorer in memory and registers for the Explorer events. /// </summary> internal class ExplorerWrapper { #region explorer wrapper events /// <summary> /// This event is fired from out wrapper when the wrapped Outlook Explorer has been closed. /// </summary> public event ExplorerClosedDelegate ExplorerClosed; #endregion #region explorer wrapper variables & properties /// <summary> /// An unique ID that can used to identify this explorer (commandbars, buttons, etc...) /// </summary> Guid _Id; /// <summary> /// An unique ID that can used to identify this explorer (commandbars, buttons, etc...) /// </summary> public Guid ID { get { return _Id; } } /// <summary> /// The Outlook Explorer object used to keep a reference in memory and register for the explorer events. /// </summary> Outlook. ExplorerClass _Explorer; /// <summary> /// The Outlook Explorer object used to keep a reference in memory and register for the explorer events. /// </summary> public Outlook. Explorer Explorer { get { return _Explorer; } } /// <summary> /// A Missing.Value used for COM interoperability. /// </summary> object _Missing = System.Reflection. Missing .Value; #endregion #region explorer wrapper construction and cleanup /// <summary> /// The construction code. /// </summary> /// <param name="explorer"> The outlook explorer that should be wrapped. </param> public ExplorerWrapper(Outlook. Explorer explorer) { try { _Id = Guid .NewGuid(); _Explorer = explorer as Outlook. ExplorerClass ; if (_Explorer != null ) { _Explorer.FolderSwitch += new Microsoft.Office.Interop.Outlook. ExplorerEvents_10_FolderSwitchEventHandler (_Explorer_FolderSwitch); _Explorer.ExplorerEvents_Event_Close += new Microsoft.Office.Interop.Outlook. ExplorerEvents_CloseEventHandler (_Explorer_ExplorerEvents_Event_Close); } } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); // throw the Exception to the calling class throw ex; } } #endregion /// <summary> /// This event occures when this explorer has been closed. /// </summary> void _Explorer_ExplorerEvents_Event_Close() { // here we release all references to the explorer from memory. _Explorer.FolderSwitch -= new Microsoft.Office.Interop.Outlook. ExplorerEvents_10_FolderSwitchEventHandler (_Explorer_FolderSwitch); _Explorer.ExplorerEvents_Event_Close -= new Microsoft.Office.Interop.Outlook. ExplorerEvents_CloseEventHandler (_Explorer_ExplorerEvents_Event_Close); _Explorer = null ; // fire an event to inform the application that this explorer has been closed. if (ExplorerClosed != null ) { ExplorerClosed( this ._Id); } } /// <summary> /// This event occures when another folder has been selected in this explorer. /// </summary> void _Explorer_FolderSwitch() { try { // We change the application menu depending on what folder we have selected // ModifyMenu(); } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); // now display a friendly error to the user MessageBox .Show( null , "There was an application error, you should save your work and restart Outlook." , "OutlookAdminTools" , MessageBoxButtons .OK, MessageBoxIcon .Error); } } #endregion } #region delegates used handling inspectors /// <summary> /// A delegate used to inform the application that an inspector has been closed. /// </summary> /// <param name="inspectorId"> The unique ID of the Explorer that has been closed. </param> internal delegate void InspectorClosedDelegate ( Guid inspectorId); #endregion /// <summary> /// The <b> InspectorWrapper </b> class is used to handle multiple open document windows within outlook. /// </summary> internal class InspectorWrapper { /// <summary> /// This event informs our application that an "wrapped" inspector has been closed and should be released from memory. /// </summary> public event InspectorClosedDelegate InspectorClosed; #region explorer wrapper variables & properties /// <summary> /// An unique ID that can used to identify this explorer (commandbars, buttons, etc...) /// </summary> Guid _Id; /// <summary> /// An unique ID that can used to identify this explorer (commandbars, buttons, etc...) /// </summary> public Guid ID { get { return _Id; } } /// <summary> /// This variable holds a reference to the outlook iitem behind the inspector. /// Used to handle to item.open event. /// Only when the item has been displayed, it's save to manipulate the inspector - or close the inspector. /// </summary> object _Item; /// <summary> /// The outlook inspector object that is wrapped by this class. /// </summary> Outlook. InspectorClass _Inspector; #endregion /// <summary> /// Initialisation code. /// Remembers the inspector in memory and registers for the close event and the item.open event /// </summary> /// <param name="inspector"> The outlook inspector object that should be handled. </param> public InspectorWrapper(Outlook. Inspector inspector) { try { // each inspector gets a unique id. _Id = Guid .NewGuid(); // remember the inspector object in memory _Inspector = inspector as Outlook. InspectorClass ; // register for the close event - used to release ourself from memory _Inspector.InspectorEvents_Event_Close += new Outlook. InspectorEvents_CloseEventHandler (_Inspector_InspectorEvents_Event_Close); // remember the item behind the inspector in memory _Item = _Inspector.CurrentItem; // register for the item_open event if (_Item is Outlook. ContactItem ) { // we have no latebinding - so we have to cast explicitly to get events Outlook. ContactItem item = _Item as Outlook. ContactItem ; item.Open += new Outlook. ItemEvents_10_OpenEventHandler (item_Open); // remember the object in memory _Item = item; } else if (_Item is Outlook. TaskItem ) { Outlook. TaskItem item = _Item as Outlook. TaskItem ; item.Open += new Outlook. ItemEvents_10_OpenEventHandler (item_Open); _Item = item; } else if (_Item is Outlook. JournalItem ) { Outlook. JournalItem item = _Item as Outlook. JournalItem ; item.Open += new Outlook. ItemEvents_10_OpenEventHandler (item_Open); _Item = item; } else if (_Item is Outlook. MailItem ) { Outlook. MailItem item = _Item as Outlook. MailItem ; item.Open += new Outlook. ItemEvents_10_OpenEventHandler (item_Open); _Item = item; } else { // we don't handle this inspector and release it from memory _Item = null ; } } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); // the wrapper is called only from application - throw the message to it. throw new Exception ( "There was an application error, the new Window could not be handled.\nyou should save your work and restart Outlook." , ex); } } /// <summary> /// Handles the item open event and checks if this item a OutlooAdminTools item. /// When we have a new item - and we are in an OAT folder - we close this item and create a new OAT item. /// </summary> /// <param name="Cancel"></param> void item_Open( ref bool Cancel) { try { Type itemType = _Item.GetType(); // check the messageclass of the new opened inspector. string messageclass = ( string )itemType.InvokeMember( "MessageClass" , BindingFlags .GetProperty, null , _Item, null ); // access the entryId - so we can get the parent folder object string entryId = ( string )itemType.InvokeMember( "EntryID" , BindingFlags .GetProperty, null , _Item, null ); // after we have accessed the entryID - we can access the parentfolder property Outlook. MAPIFolder parent = itemType.InvokeMember( "Parent" , BindingFlags .GetProperty, null , _Item, null ) as Outlook. MAPIFolder ; string folderName = parent.Description; int itemSize = ( int )itemType.InvokeMember( "Size" , BindingFlags .GetProperty, null , _Item, null ); } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); // the wrapper is called anytime from application. // display a messagebox directly to the user MessageBox .Show( "There was an application error, a new Window could not be handled,\nyou should save your work and restart Outlook." , "OutlookAdminTools" , MessageBoxButtons .OK, MessageBoxIcon .Error); } } /// <summary> /// This event occures when the user has closed the open inspector. /// Used to release ourself from memory and avoid memory leaks. /// </summary> void _Inspector_InspectorEvents_Event_Close() { try { _Item = null ; _Inspector.InspectorEvents_Event_Close -= new Outlook. InspectorEvents_CloseEventHandler (_Inspector_InspectorEvents_Event_Close); _Inspector = null ; GC .Collect(); GC .WaitForPendingFinalizers(); if (InspectorClosed != null ) { InspectorClosed(_Id); } } catch (System. Exception ex) { // log the error always Trace .TraceError( "{0}: [class]:{1} [method]:{2}\n[message]:{3}\n[Stack]:\n{4}" , DateTime .Now, // when was the error happened MethodInfo .GetCurrentMethod().DeclaringType.Name, // the class name MethodInfo .GetCurrentMethod().Name, // the method name ex.Message, // the error message ex.StackTrace // the stack trace information ); // the wrapper is called anytime from application. // display a messagebox directly to the user MessageBox .Show( "There was an application error, a Window close could not be handled,\nyou should save your work and restart Outlook." , "OutlookAdminTools" , MessageBoxButtons .OK, MessageBoxIcon .Error); } } } Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
- Next
  - 1
    - Problem with installation Hello, I have problem with Tools for Office SE. When I try to create some project in Visual Studio with Tools for Office I get message, that I should install 2003 with SP1. I was doing: 1. I had office 2003, I upgraded to 2007 trial, but Visio and FrontPage was not upgraded. 2. I removed trial and bought and installed full version of 2007 also without Visio and FP. 3.I tried few times reinstall Tools for Office SE but it did't help. 4. I removed all 2003 products and again reinstall Tools for Office but also didn't help 5.I installed PrimaryInteropAssembly for Office 2007 but unfortunatly didn't help. Please very much help me Thank you a lot and best regards, Milosz Kukla Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 2
    - Newbie Question VSTO v. VS 2005 Pro Veloz wrote: So what I'm getting here is that VSTO won't help me "automate" Office apps in any way (in the sense of a separate application "controlling" Office). Right If we used VSTO and wanted to fire up Excel and programatically populate a worksheet with data it would be the same code as if we were using VS 2005 Pro, right (That is, we'd essentially be using COM/Automation in either tool) Basically, that's correct, yes. Although you wouldn't use VSTO to fire up Excel. The VSTO tools all work within an already running version of Excel. They're primarily for providing an interface with the user. But the code that does the work in Excel would be the same for VSTO as for general automation. Veloz wrote: I was sort of hoping that with .NET, MS would have provided a managed way to interact with office apps from within managed code in an application. No, the Office applications remain COM. .NET can't do anything about that. The only Office app with a .NET programming language is InfoPath, which was developed after .NET was in existence. It uses VSTA (Visual Studio for Applications). Currently, the strategy for the "classic" Office applications, in the newer versions, is to make it possible for the developer to do pretty much everything without Office needing to be present. So documents can be processed server-side, for example. This is all being done with XML. If you were interested in Word, rather than Excel, then that would be an option for 2003 because Word provided a fairly complete XML vocabulary. The XML for Excel 2003 is limited to basic table construction; no charts, no pivot tables, etc. While it is possible to generate Excel 2007 files completely using XML, Excel 2003 users can only open the files. They can't save back to that format (unlike Word). Veloz wrote: Do you know of any good resorces/examples for using automation in c# inside either VS 2005 Pro or VSTO A good place to start is the MSFT Knowledge Base and the VSTO and Office parts of the MSDN site. You'll find a number of "How to" kinds of articles. In the KB, search terms like: Excel C# or Excel .NET This is the entry point for VSTO on MSDN . The articles there with C# code for the object model will apply outside of VSTO, as well. Then there's the book "Visual Studio Tools for Office" by Carter and Lippert. There are two separate versions, one for VB.NET and the other for C#. Quite a large portion of the book covers working with the object models. The discussions don't go into depth, and don't cover everything, but you at least have a good head start on the object model, so it probably would be helpful. Beyond that, I'd say search for code samples in this forum, as well as across the office.developer newsgroups (see the Please Read First message for links). Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 3
    - Use VSTO for synching without outside apps? Table has a nice GetArray function. It's very fast. If you want to do server-based processed, I definitely wouldn't waste any time with an Outlook add-in. But Exchange apps use completely different APIs. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 4
    - Send current item not working - Code provided The code below worked fine until I introduced the ArrayList functionality. Basically, what I want to do is test each recipient and retain only the ones that match a certain keyword. I looked arround and the ArrayList seemed to do what I wanted and while it does, some how my Appointment item won't send the update message. VSTO 2005 and Outlook 2003 Pro Dim myItem As Outlook.AppointmentItem = _Inspector.CurrentItem Dim myArray As New ArrayList Dim x As Integer Dim myRec As Outlook.Recipient Dim count As Integer = myItem.Recipients.Count Do While count > 0 For Each myRec In myItem.Recipients If myRec.Address.Contains("myDomain.com") Then myArray.Add(myRec.Address) End If myRec.Delete() Next count = myItem.Recipients.Count Loop myItem.Save() For x = 0 To myArray.Count myItem.Recipients.Add(myArray(x)) Next myItem.Save() myItem.Send() Any help is greatly appreciated. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 5
    - VSTO, ActiveX, and Powerpoint Is it possible to create an ActiveX control to embed into powerpoint for interactivity and create it using VSTO/C# Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 6
    - Word 2007: How to determine the paragraph ID/section ID/ font type at the current cursor location using VSTO 2005 SE Hi, I need to write code that will fire events when the user switches paragraphs/sections and changes the font face/changes the style etc on a Word 2007 document. Any suggestions Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 7
    - Use Outlook 2003 to send meeting request using c# You already answered your own question: You need to build an Outlook COM add-in. Since you can't use VSTO, you need to use the IDTExtensibility2 (shared add-in) interface. If you derive all Outlook objects from the Outlook.Application object passed as an argument by the OnConnection event, properties and methods of those objects won't trigger security prompts. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 8
    - NewInspector no longer fires after UI involvement Glad to help! Yes, this would be true for Explorers also if you were hooking up to the Explorers.NewExplorer event. Mike Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 9
    - Newly Added Document is NOT the Active Window Hi, I am still a little confused about your scenario. Did you write the dll or get it from somewhere It makes no sense that you can use this statement this.Documents.Add to interact with the Office application. Could you please post the exact codes in your class library :-) Thanks Ji Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 10
    - How to find runtime properties in Word Dialogs? pnp wrote: I don't wan't to execute it... I just thought it would be nice if Word had found the first instance that was subject to replacement. Nothing else. The tool will work fine by setting the properties, the last thing here was just a small nicety. If the user don't check interactive, then i will use the Range.Find(...) method directly, not even showing the word app. It's only for the case where the user is a bit uncertain, or if the user knows that the word might be replaced too much if not guided. E.g. replacing the the word 'driver', will both replace the one handling the car, and the biggest golf club in the bag. I'm still not sure I follow your thinking. How should your code know when the user is satisified, looking at the dialog box, if he doesn't click anything If you're afraid he doesn't know what "FindNext" means, then you'd need to create your own dialog box interface. If you want to execute the Find as "Find Next" no matter what, then use the Display rather than the Show method. Display won't execute the dialog box, no matter what the user clicks. That's up to your code. Most of the dialog buttons will return a value, although if there's more than one (as is the case with the Find dialog box) you have to do some testing to find out which values are returned by which buttons. Roughly: Dim retVal as Long retVal = wdapp.Dialogs(wdDialogEditFind).Display MsgBox CStr(retVal) If retVal = 0 Then 'User probably clicked "Cancel" or "Close", meaning no action ElseIf retVal = 1 Then 'This is often the OK button, but it could be -1 End If Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 11
    - VSTO, ActiveX, and Powerpoint Is it possible to create an ActiveX control to embed into powerpoint for interactivity and create it using VSTO/C# Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 12
    - How can I put data in Word Documents??? Hi Galo Another (perhaps better) place to first search, then ask, would be the office.developer.automation newsgroup . You're more likely to find people there who "do" .NET than in the end-user/VBA targeted mail merge newsgroup. And a (Google) search of all the office.developer newsgroups should turn up some discussions and samples for populating bookmarks. If you have to ask, don't forget to mention which programming language you're using so that any code samples are "on target" for you :-) Note: you'll find a list of newsgroups (for non-VSTO Office stuff) in the Please Read First message at the top of this forum. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 13
    - Iam merging lot of word documents into one single document and atlast doing a pdf Hi Prasad Indeed, when copy and inserting files Word does have a tendency to behave differently when the user is doing it than when code is used. You understand, I can't say for certain that this is what's happening in your case. To be certain, one would have to actually analyze the documents and the code. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 14
    - Dynamically creating Excel Sheets and Charts from .NET 2.0 App Hi, We are developing a reporting application for our company internal purpose. For this, the application fetches various types of data from different data sources and accumulate these into its local data source. Based on the data, it has to generate report for various formats for selected periods. The report would be prepared based on the number of products selected by the user. It should generate report for excel also. After dynamically filling excel, it has to create chart based on data in the sheet. We are analysing the feasibility of using XMLMap, XML List, XMLSS in Excel to achive this. If anybody have idea about this, please share with me. Thanks in advance. Regards, Udooz. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 15
    - how discover macros programatically? Hi Freitas No, this question is not VSTO related. VSTO is a set of tools for creating application-level add-ins and document-level customizations (replacing embedded VBA code with .NET code) - for Office 2003 and later. It has nothing to do with ASP.NET. As Dennis recommended, check the resources in the Please Read First message at the top of the forum. Use one of the office.developer newsgroups. FWIW, default user security options will block you from accessing VBA projects (macros) embedded in Office application files. If you're creating this project for a company, check with the IT department whether the setting to allow access to the VBA projects is enabled in their environment. If it is, you can get further information from the newsgroups. You'll need to work with the VBE extensibility library, that has objects such as VBComponent and VBProject. You should be able to turn up code samples doing a Google Groups search on the office.developer newsgroups. Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office
  - 16
    - Drop downs in excel 2007 Hi Dhruvan, I am still not very sure about your saying of Drop down Control. As you say that you want to insert them into the cells, I guess you are working with Excel 2007 document-level project, right My reason for such a guess is that the application-level solution does not support to insert a control into a cell. It only support add a control on the surface of the sheet. So you are using VSTO3 (still in Beta2), right If yes, I think, you can add a new Item Class include the fields of Display Value and Store Value. And Overwrite its ToString() method to return its Display Value. I have a quick test and success in my side with the following codes: In the Sheet1.cs: Code Snippet private Microsoft.Office.Tools.Excel.Controls. ComboBox comboBox = null ; private void Sheet1_Startup( object sender, System. EventArgs e) { comboBox = this .Controls.AddComboBox((Excel. Range ) this .Cells[1, 1], "test" ); comboBox.Items.Add( new Item ( "item1" , "My data 1" )); comboBox.Items.Add( new Item ( "item2" , "My data 2" )); comboBox.Items.Add( new Item ( "item3" , "My data 3" )); comboBox.Items.Add( new Item ( "item4" , "My data 4" )); comboBox.SelectedIndexChanged += new EventHandler (comboBox_SelectedIndexChanged); } void comboBox_SelectedIndexChanged( object sender, EventArgs e) { Item i = ( Item )comboBox.SelectedItem; MessageBox .Show(i.data); } The Item Class: Code Snippet public class Item { public string name; public string data; public Item( string n, string d) { this .name = n; this .data = d; } public override string ToString() { return name; } } Hope this can help! Thanks Ji Tag: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word Office

Jake Reynolds

Can anyone inform me of some best practices on how to bind repeating XMLNodes to a dataset I just want to be able to display a field in a database inside of XMLNodes mapped into my document. Some of these may be variable in amount depending on the amount of rows returned. The XMLNode host control is easily bound but what options are available to bind data to repeating nodes Do I have to manually navigate the document structure and fill in XMLNode.Range.Text or what

Thanks,
Jake

Top

Re: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word

Mohit Gupta - MSFT

Hi Jake.

For XmlNodes host control, there is no data binding support that VSTO provides. You need to perform this binding manually.

Thanks

Mohit.

Top

Re: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word

Jake Reynolds

Thanks for the reply. Do you know of any good example code out there regarding manually populating repeating XML nodes

Thanks,
Jake

Top

Re: Visual Studio Tools for Office Binding Repeating Nodes to a Database in Word

Mike Walker

You could edit the document outside of word and use a basic XML Dom to repeat data inside with a foreach loop. Alternatively I would need a lot more information on what type of document and data you would like to repeat.

Regards

Top