Office

Page 34




  • Topics
    Replies
    Last post
  • Objects as Results of Excel UDFs
    by ChrisSpicer
    6 Replies
    Last post by Denis BDA
      • I'm looking to create a two stage process to my calculations: I want to create a UDF that will generate an object, then another UDF that will reference that object. As a specific example, I want to calculate the yield of a bond. There a several pieces of static data required to do so (maturity, coupon, etc), plus some volatile data (namely price). I would like to use my first function to create a
  • Multiple windows
    by Denis Pitcher
    2 Replies
    Last post by Denis Pitcher
      • I've got an odd issue that I'm uncertain how to resolve. I'm running VSTO 2005SE with Office 2K3. I've added buttons to the toolbars that open windows. The odd thing is that when I click the button, it opens as many windows as there are powerpoint instances. I have no idea why a click in one instance causes the event to be run in all. I've tried setting it so that it c
  • Using Microsoft.Office.Interop.Word events without VBA installed?
    by MarchandD
    3 Replies
    Last post by Maarten van Stam
      • I have a project which involves wrapping Word in a C# package on a system where VBA is not installed -- and won't be. I'm running into a problem adding event handlers, though. Sample code is given below: ---- Word. Application gWordApp = new Word. Application (); gWordApp.DocumentBeforeClose += new Microsoft.Office.Interop.Word.ApplicationEvents4_DocumentBeforeCloseEventHandler(th
  • Getting Microsoft.Office.Tools.Excel.Worksheet from an application level add in
    by benchr
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • I found the code here to create the Microsoft.Office.Tools.Excel.Worksheet wrapper for a dynamically created worksheet. https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2169214&SiteID=1 But this does not work from an application add-in. There is no RuntimeCallback object. I want to create an add-in that can put a managed winforms control on the active sheet of w
  • COM Exception from Excel When Opening Workbook
    by slide23
    9 Replies
    Last post by Dhanya
      • Hello all, I am attempting to open an XLS file through the PIA. I am using the Workbook.Open() method. On calling the method, I get a COMException with no information in it. The error code is -2146827284, Help Link is "null," and the only message is "Exception from HRESULT: 0x800A03EC." The only thing I can pin this down to is that there is some issue in t
  • Outlook Exchange server address
    by ssundan
    4 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I need to get the exchange server address(name), user name, email id, password from the outlook programmatically using C#. Outlook is already configured. I need to get the details. I was able to get the AD user name using the following code Application objOutlook = new Application (); // Get items in my inbox. NameSpace outlookNS = objOutlook.GetNamespace
  • Creating a shape fill with color in interop Power Point Object Library
    by Yuen Li
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi! I am using Microsoft Power Point Object Library to draw a shape that will fill in color. Does anyone know how to do that I am able to draw a shape with this code objAllShape = objSlide.Shapes.AddShape( MsoAutoShapeType .msoShapeOval, 150, 300, 100, 50); but when i wish to fill in color with the code below, it seem cannot work. objAllShape.Fill.BackColor.RGB = RGB(255, 2
  • How to write an Outlook Add-In
    by Kirk Evans
    7 Replies
    Last post by Kirk Evans
      • I already have an application that will dial a phone in our phone system, and it accepts command line parameters ( specifically, the number to dial - each installation knows which phone it is controlling ). I want to be able to launch this application (with the parameter ) from outlook. I'm imagining a button on the Outlook toolbar that would perform this action. Somehow I'm going to need t
  • How to Create a new xls document from Excel addins (VSTO 2005 se / Excel 2003)
    by Lin Kejian
    2 Replies
    Last post by Linkejian
      • How to Create a new xls document from Excel addins (VSTO 2005 se / Excel 2003)
  • VSTO SE Soft disable
    by Janni Kajbrink
    14 Replies
    Last post by AllTec
      • Hi, I'm having the exakt same problem as described in the following article http://blogs.msdn.com/pcreehan/archive/2006/07/06/vsto-add-ins-and-the-newinspector-event.aspx . I've written an empty VSTO SE add in which is "soft disabled" as soon as Outlook is started without any user interface. Is there any solution to this problem As most of the users who will be using my add
  • VSTO SE Install
    by pdxmonk
    6 Replies
    Last post by pdxmonk
      • I have Office 2003 and Visual Studio 2005 installed on my PC. I downloaded and installed VSTO SE. Install seemed to go fine, with "successful install" and no error messages. When I open Visual Studio there are no "project templates" for Excel or Word. I have uninstalled and reinstalled several times. I seem to have only one occurence of Office on thi
  • More on Exception from HRESULT: 0x800A03EC
    by garretth
    8 Replies
    Last post by garretth
      • I've been trying to trace this error down and I've found a curious thing. 1) When I put a breakpoint on the ThisAddin.Designer.vb New method, I find that it appears to be the first line called. No surprise. What is surprising is that I have an exception before that line executes. A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll 2) When I step thr
  • VSTO se sorting problem
    by MothDoc
    13 Replies
    Last post by MothDoc
      • Hi Ji I am trying to do something similar but I am afraid I am getting nowhere. I am trying to build a function within excel that will allow one to stipulate the performance of calculations and other formulae based on the cell background colour. For instance I have a column of figures B2:B9 with the following values and cell colours B2: 2 pink B3: 3 white/no colour B4: 0 pink B5: 0 white/no colo
  • Bug in Microsoft Word IncludePicture Fields
    by Adrian Leeming
    5 Replies
    Last post by Cindy Meister
      • While working in Microsft Word on a project I discovered a bug, hopefully one of the MVP's can report it as it seems they are looking at their buffers incorrectly. Its not exactly a VSTO problem as it can be recreated without saving via VSTO calls. A user has some INCLUEDPICTURE fields with extra information after the filename that they picked up in another process later. When this document
  • Turning one Word Bookmark into two separated Bookmarks
    by Herman Solberg
    2 Replies
    Last post by Herman Solberg
      • Hi! I'm building a Word 2003 addin with VSTO 2005 SE. In my solution I need a method which should turn an existing Bookmark into two Bookmarks with a blank space in between. The original Bookmark is located in a Table cell in the document header. Before the method runs it looks something like this (brackets represent start and end of a bookmark): [Content] When the method is d
  • How can I get a list of users that are currently connected to a Microsoft Access Database using C# in .Net?
    by Funday
    1 Replies
    Last post by Mohit Gupta - MSFT
      • I'm using c# in Visual Studio 2005 Enterprise, trying to retrieve a list of users currently logged onto a Microsoft Access 2002 Database (or at least a count of them, but if I can get a count, I should be able to get the list). My database has user-level protection (User Name/Password, no password on Admin User, no Database Password). Here's what's installed for data access: ADO Version 2.8
  • How to get VSTO.
    by Tim5827
    5 Replies
    Last post by suneelpotluri
      • I am a college graduate with no money. I use Visual C# Express editions. I am sick of using VBA. I want to use VSTO but it requires an expensive Visual Studio version. Is there any way I can get my hands on it
  • Custom Oulook Forum
    by AllTec
    1 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi I am new to VSTO and outlook programming. I want to cutomize outlook form and want to have its interaction with database. I want to use VSTO. I am not sure how I can make interaction possible, how to load form controls (dropdown) from database and then save selected dropdown value in database. If someone has good link or sample code. Please share. Thanks AllTec
  • WordApp.Selection.Range.set_Style throws exception
    by andriscs
    3 Replies
    Last post by andriscs
      • Hi, I'm trying to create a Word document and I need a table of contents. I have different sized text and I tried to set their style according to the planned display. However, I get an exception when I try to call set_Style method. Why does that happen Here is the code: Code Block object styleHeading2;object styleHeading3; in the calling method: Code Block styl
  • Outlook addin stops responding
    by Siddhu
    6 Replies
    Last post by Misha Shneerson - MSFT
      • Hi, We have built a VSTO-SE add in for Outlook 2003. Our add-in functionality can be be initiated in 2 ways, manually or can be set to initiate after given period of time, something like "auto send/receive mail" functionality. But sometimes when our add-in initiates a process (e.g. auto initiate process) outlook stops responding and crashes. We have to forcefully kill the Outlook proces
  • Create Right Click Menu Items in Outlook 2007
    by Rudolph Scott
    5 Replies
    Last post by Sue Mosher - Outlook MVP
      • Does any one know how to do this with VSTO 2005 I can see VB code on Top Level menu items but not when you right click an e-mail. Any help you can give would be usefull. Thanks.
  • Is it possible to create a plugin that fetches a contact list from an external source, when you create an email ?
    by TomJ72
    3 Replies
    Last post by Sue Mosher - Outlook MVP
      • When you are creating a new email in outlook 2003, there is a dropdown list "select names from" (or something like that, I do not know since I do not have the english language version). I would like to attach a new option to this dropdown and when that new option of mine is selected, it will trigger a method of mine that will fetch the contacts from an external source (through a web ser
  • ConfigurationManager
    by Lily Collins
    2 Replies
    Last post by Lily Collins
      • I am using Visual Studio 2005 Professional edition with VSTO SE. I have .NET Framework 2.0 (and 1.1) installed. I am trying to write a method that captures a value from the app settings section in an app.config file (I am writing an Outlook 2007 add-in) , I have a using directive as follows: using System.Configuration; When I try to use the ConfigurationManager class it i
  • Change format of excluded parts of a protected document
    by ClaudiaHelpOnVSTO
    4 Replies
    Last post by ClaudiaHelpOnVSTO
      • Hi, I apply protection to my Word document programmatically. To allow the user to edit only specific content I then exclude specific parts. Unfortunalty Word formats the excluded parts by opening a bracket in front and a closing bracket at the end of the editable range. In addition, it colors the background yellow-gray. How can I get rid of this ugly formatting Thanks, Claudia
  • Need help with OL2003 and context menu
    by sklett
    7 Replies
    Last post by srinin
      • It's been 5 days now and I'm still at square one. I must being doing something very wrong in my add-in. The problem I'm having is that my add-in seems to crash (or the events are being 'disconnected' somehow) I have a simple add-in that inserts a CommandBarButton in the context menu of the MailItem list. The code inserts the button fine, but when I start to use outlook a little my code eventually