Office

Page 192




  • Topics
    Replies
    Last post
  • Thanking and I need one more Help!
    by iicDotnet
    10 Replies
    Last post by iicDotnet
      • hello friend i am try to cerate Action pane for word document but am getting NullReference Exception and am choosing MSWord Addin Project and Am using MS office 2003 help me Using VS2005 and VSTO2e thanks in advance
  • Command Bar doesn't seem to show up
    by Blinocac200sx
    6 Replies
    Last post by Blinocac200sx
      • using System; using System.IO; using System.Text; using System.Windows.Forms; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Word = Microsoft.Office.Interop.Word; using Office = Microsoft.Office.Core; using Microsoft.Office.
  • Extended Report Footer
    by Sandyee
    1 Replies
    Last post by Cindy Meister
      • Hi all, In our project we are making use of MS Office 2007. We are lauching the reports in Excel. We populate the data through the Vb.Net coding into Excel. In our reports we are showing Report Footer after the population of the data. For eg. My query is returing 10 Rows so we are showing the Report Footer on the 11th row. But what is happing is my report footer is too big in length a
  • Custom Task Panes and Multiple Windows
    by dirty-shirt
    2 Replies
    Last post by dirty-shirt
      • Hey all, so I've looked through the forums already, looks like the issue of a "pure Application-level" Custom Task Pane is still yet to be documented. Well here's what I've got. I'm instantiating a new custom task pane everytime I open or create a new document. So basically I've put the code inside the Addin Startup, Open Document and New Document event handlers. This runs fine an
  • Creating a Task in the non default folder
    by JP O'Gormannn
    3 Replies
    Last post by JP O'Gormannn
      • Hello, I want to create a Task in a non default tasks folder. I see that there is a Move option on the task to move it to another folder. This is not appropriate for me. The .Parent on the task is only a getter so that is no good for what I need. Any help would be appreciated. Regards, JP Outlook.MAPIFolder nonDefaultTaskFolder = ...; Outlook.TaskItem newTask = (Outlook.TaskItem) oNS.Application.C
  • Problem with Installer
    by Malleswar
    9 Replies
    Last post by Malleswar
      • Hi, I have prepared installer for Excel Ad-in. I have installed manually VSTO and PIA, Coz target machine was giving problem to install them thru installer. Atleast it didnot work in this way. It copy the dlls from my setup and does nothing else. When I run from IDE it works fine and also the same setup working on when I run on the same machine where I developed. I have given the code. Can an
  • Font size in Outlook
    by DotNetGuy_03
    2 Replies
    Last post by Brent Williams - MSFT
      • Hi, How can I set Font size as 11pt in Outlook 2003. I set the size as 11 pt in Tools->Options->Mail Format->Fonts. But if compose a new message, it shows the font size as 12 pt in the font combobox. Thanks, Mano
  • WinForms Object Error (Windows Vista & Office 2007)
    by Douglas H. Troy
    3 Replies
    Last post by Douglas H. Troy
      • System Config(s): Windows Vista Ultimate with Office Ent. 2007 Office 2007 PIAs VSTO 2005 SE (have also tried with original VSTO 2005) also tried on Windows XP with Office Ent. 2007 VSTO Solution: Word Template Document-Level Customization Basic test application that contains a custom Action Pane with a button. The click event of that button creates an instance of a custom WinForm control and ad
  • Change a picture in Word 2003 Actionpane app
    by ManniAT
    18 Replies
    Last post by ManniAT
      • Hi, I build a "from filling" application useing a VSTO Word Document. The document must follow a strict an precise layout. So first I filled the document and made the layout. In an action pane I select some product data and when hitting a "create button" I fill bookmarks in the document with text. Now my problem - in my document I have two small pictures.
  • Managed UDFs for Excel 2003 with VSTO 2005 SE
    by Karlma
    5 Replies
    Last post by Karlma
      • Hi, I am developing some User Defined Functions (UDF) for Excel 2003 using Visual Studio 2005 Team Edition for Software Developers, and I have VSTO 2005 SE installed. The solution is currently an Automation Add-In (VB class library) that fetches some data and does some calculations on a MS SQL Server 2005 by calling stored procedures. I have basically followed the instructions from Eric Car
  • Creating Word 2003 doc and can't find word template projects with VSTO SE
    by beachboy1976
    1 Replies
    Last post by Cindy Meister
      • Hi, I am creating word doc in VS 2005 and C#. I installed VSTO SE on my local machine. When I went through the steps to create a document-level word template, I couldn't find the template. I only saw the word add-in under the list. Can anyone explain to me if I miss anything I am using Office 2003. Thank you
  • VSTO Without Office Installation
    by Sathyags
    5 Replies
    Last post by Cindy Meister
      • Hi All, Is it possible to use VSTO without office installation in the production machine. Office can be installed in the machine during developement. but when deployed there is not office installation in the server for some security reasons, so is there a way to use VSTO without office installation. thanks sathya
  • Install for "All Users" (VSTO)
    by John McCarvill
    14 Replies
    Last post by SteveAbram
      • I am curious of how best to handle the situation of installing a VSTO addin for a non administrator user, when installing VSTO Redistributable requires the user to be an admin. If an admin could install the VSTO Redistributable and the addin (configured for all users) it would simplify distribution and setup of the application. Any thoughts would be helpful.
  • gallery shared with dropdown??
    by jaz
    2 Replies
    Last post by jaz
      • Hi, How can I use a dropDown in a gallery I want to develop a custom menu in that i want to use a drop down .. i tried the following <menu id ="menuToolsTracking" label="Tracking" > <dropDown idMso="ReviewDisplayForReview"/> </menu> But not working How can i do that. . May I use gallery to achieve this . Then how Can u
  • No References For Office 2003 Interop
    by cdun2
    6 Replies
    Last post by cdun2
      • Hello, I have been through the wringer this morning trying to create references to the Office 2003 Interop assemblies (VS 2005). I am trying to reference the assemblies through an SSIS script component. When I right click 'References' in the Project Explorer for the script and select 'Add Reference', I can clearly see that none of the Microsoft.Office.Interop asseblies are listed. I can see
  • Addin fails to load a DLL which had its version updated.
    by sameera
    9 Replies
    Last post by sameera
      • I have a Excel document level customization project that is dependant upon another common class library project. When I increment the version number of the class library the VSTO project fails to load it during run time. The exception I get: Could not load file or assembly 'CommonLibraryPrj, Version=1.0.0.0, Culture=neutral, PublicKeyToken=69128d937baea9c7' or one of its dependencies. The located
  • VSTO Excel addin works on one machine but not on an (almost) identical other one
    by AlisterN
    12 Replies
    Last post by AlisterN
      • My Excel addin installs successfully on machine 1, and although it is successfully installs (according to the application event log) on machine 2, it does not work on machine 2. (The addin adds a button to the toolbar. The button does not appear on machine 2). Code within the ThisAddIn_Startup does not get called onmachine 2. The installation is created by the standard setup project asso
  • How to combine two ranges?
    by Dmitriy Ovdienko
    12 Replies
    Last post by Cindy Meister
      • Hi All Do you know any method that can combine two ranges Using following code I can't achieve this because COMException is raised with HRESULT 0x800A03EC: using Microsoft.Office.Interop.Excel; Range r = sht.get_Range( "B2,C3" , missing ); // faires COMException with HRESULT = 0x800A03EC:
  • Visual Basic vs. Visual C++
    by CreativeSE
    10 Replies
    Last post by CreativeSE
      • Which is a better application to use if the application has to interface with Excel A LOT What are the pros and cons of both I've used Visual Basic but haven't used Visual C++ with Excel
  • COM Exception in CommandBars["Task Pane"].Visible = true
    by mobigital
    6 Replies
    Last post by John R. Durant - MSFT
      • I am getting this occasional COM error when trying to ensure that Document Task pane is visible: This code: Globals.ThisWorkbook.Application.CommandBars["Task Pane"].Visible = true; Causes this exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at Microsoft.Office.Core.CommandBar.set_Visibl
  • Upload data to DB from existing worksheet using Excel Add in for Office 2007
    by Darshan Parekh
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I want to upload data in DB from the current worksheet on click of button on the Ribbon. This should be Office 2007 SnapIn solution. I will be highly obliged if any one can give me refrence of any relevant example/sample code/link for this. This is my first exposure to VSTO. I have been searching a lot on VSTO + Excel + SnapIn smaple code, but unfortunately no luck so far. I am sti
  • Syntax of AddOleControl
    by Roman Benko
    1 Replies
    Last post by Cindy Meister
      • With VSTO SE, there is an AddOleControl method associated with Microsoft Word's InlineShape object. However, every time I try to use it, I get a "Type Mismatch" error when that line executes. Here is the code I'm using: Dim myDoc As Microsoft.Office.Interop.Word.Document = Globals.ThisAddIn.Application.ActiveDocument myDoc.InlineShapes.AddOLEControl _ (ClassType:= "testCont
  • How to create range selection frame?
    by Chernichkin Stanislav
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • How can I programmatically create frame which allow user to adjust data range selection (don't know control's name exactly, see picture at http://www.infosyst.biz:8862/excel.png ) InputBox almost brings desired functionality, but I need multiply frames (as chart does) and I have to control them from my form. Thanks.
  • Can I install Office Home 07 twice on same machine
    by Akram
    2 Replies
    Last post by Akram
      • I bought the Office Home 2007, my understanding I can install it on 3 different computers. My current computers are Win XP, if I install the Office now on the 3 machines, will I be able to re-install the Office 2007 once again if I up-grade to Windows Vista.
  • Assignment of text to "WordApp.Selection.Find.Text" stops my application - why?
    by TomySeb
    5 Replies
    Last post by TomySeb
      • Hi, I am using COM component to make a find and replace in a word document. A very strange thing happens to me. I am able to open the document, and insert text in it. But when I do a Find and Replace, my application gets stopped at the line where I have given the code as WordApp.Selection.Find.Text = "MySearchText"; When I debug, the execution of the code reaches this line