Office

Page 5




  • Topics
    Replies
    Last post
  • Create Action Button
    by Hussain Saffar
    7 Replies
    Last post by Cindy Meister
      • How to Create an Actionb Button in MS Word Using VSTO This Action should read fax number send as a fax Anyone can help me or give me a hint to this please
  • VSTO SE System_Com object properties
    by Lily Collins
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • I am using VSTO SE in the development of an Outlook 2007 add-in. I have been creating MessageBoxes or creating variables to see System_Com object properties when debugging as I only seem to be able to see Base and Non-Public members (in ASP.NET development I can see all properties for an object in the locals window). Am I missing something or is this how I have to view properties if using C
  • VSTO 2005 SE Installaion issues
    by NemanjaTheLost
    13 Replies
    Last post by Amol Gholap
      • hi, i'm having problems with the installation of the vsto. i run the vsto 2005 se installation package and the PIA install for office 2003 but when i try to run code samples i get the following error: Error: The operation could not be completed. No such interface supported this also happens when i try and build my soulution. am i doing something wrong or are there any known conflicts wit
  • No Office Templates
    by AFM
    2 Replies
    Last post by Harry Miller - MSFT
      • I thought I asked all the right questions before replacing my VS 2005 Standard Edition with VS 2005 Pro.  VSTO SE documentation announced it would now included VS 2005 Pro in its release. (If I remember correctly, this was proclaimed as its number one request!!!)   Either I miss read it, or the article  neglected to state the limitations the VS Pro - VSTO
  • VSTO 2005 SE PowerPoint add-in setup issues
    by Andy_T1
    3 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi! I have a 2005 SE PowerPoint add in that must be written in VB.NET. The example project from microsoft that sets security via custom action is written in C#. I compiled the set security project into a dll and included it my setup project. I also created four custom actions as outlined in the sample project and added setsecurity.dll to them and specified the proper CustomActionData parameters. I
  • (Excel) Does copy/paste trigger an event?
    by W.Lau
    1 Replies
    Last post by Asim Patnaik
      • Hi, I'm writing a VSTO Excel program right now and I'm stuck at this point. When the user copy/paste cells, I need to know what was copied. I thought it would be under the worksheet.change event, but it doesn't fire when I paste a series of values into an area of cells. For example House | Old Date | New Date 1 01/01/07 2 02/01/07 3 03/01/07 The entire worksheet is protected, I have
  • Capturing Category Change Event
    by DuBrowgn
    3 Replies
    Last post by DuBrowgn
      • I'm writing an add in for Outlook 2007. What I want to be able to do is run some code when ever the user changes (sets or clears) a specific category on a mail item. So if the user decides to categorize an Email they got as "management," my add in would run some code based on that category. Thanks for any help you can offer!
  • 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 Studio Tools for Office SE - Add Reference to PIA problem!
    by yarini
    2 Replies
    Last post by Brent Williams - MSFT
      • I had installed PIA ( Primary Interoperability Assemblies for Office 2007) after install VSTO SE. Then I am trying to build and add-in and I fail trying to add a reference to Microsoft.Office.Interop.Word. I am running Windows Vista and Office RTM and a VST Suite edition. Any idea -yarini
  • MergeWorkbook does not work, SaveCopyAs works.......... ideas?
    by Saurabh.Gupta
    12 Replies
    Last post by JommyChen
      • The following works good, except for, when I open the saved copy it tries to load the Customization assembly. Globals.ThisWorkbook.SaveCopyAs(absoluteFilePath) I tried code to remove customization, but as per the code, no customization exists. Any help, hugely appreciated! If (ServerDocument.IsCustomized(absoluteFilePath)) Then 'false ServerDocument.RemoveCustomization(ab
  • Hide Inspector
    by thehin
    9 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hello Everyone, I am trying to follow the example shown here: http://www.outlookcode.com/codedetail.aspx id=616 . This example is a work around which allows one to get the start date and end date of a selected calendar range. I am using VSTO 2005 SE and Outlook 2007. Everything works great, however there are a few problems. The following code is what I would like to do: Code Block
  • Excel sheet delete/rename/move/copy
    by msexceller
    8 Replies
    Last post by msexceller
      • How do I handle following events in excel 2003 (with C#) sheet rename sheet delete sheet move sheet copy Also, is it possible to disable only a few options in sheet right click popup menu Protecting the workbook is not acceptable in my case. thanks...
  • Using the Server Capabilities in Microsoft Visual Studio 2005 Tools for Office to Build a Benefits Registration System
    by LPL29
    2 Replies
    Last post by LPL29
      • Hi, I've installed the sample OfficeVSTOBenefitsRegistration.msi from http://msdn2.microsoft.com/en-us/library/aa537190(office.11).aspx It runs well when I use the default ports (2420 for the C# and 2288 for Vb.NET) but I get this error when I configure the web application to use any other ports: I've already got a fix from MS http://support.microsoft.com/kb/915781 but I still get this error, I
  • How can i use VSTO 2005 to open, modify ans save a word document directly on server(IIs on local machin) in asp.net application?
    by Vijay Panchal
    9 Replies
    Last post by jinishans
      • hi I want to open , modify and save a microsoft document file directly on server (on IIS on my machine). Is it possible with VSTO 2005 with asp.net If yes then how. Pls help me. Thank in advance Vijay panchal
  • 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.
  • How to duplicate a RichTextContentControl
    by mathmax
    10 Replies
    Last post by dhysong
      • Hello, I try to duplicate a RichTextContentControl from a word 2007 document. I would like to insert the duplicated RichTextContentControl just under the original one. How can I do that Thank you in advance for your help, mathmax
  • GetFormRegionIcon Never Called
    by Jared Brogni
    3 Replies
    Last post by Anifarsh
      • I'm using VSTO SE to create a form region add-in for outlook. My form is being correctly displayed, but it is not displaying my icon in the ribbon control button that is created for my separate form. When I try and debug what is happening in GetFormRegionIcon, it is never called. Does anyone know why this would not be called at all, but when GetFormRegionStorage is being called correctly Thank yo
  • Creating Emails with Visual Studio 2005 and Outlook 2007
    by Rudolph Scott
    3 Replies
    Last post by Rudolph Scott
      • Hi. I'm trying to write code to do this. I am using Visual Studio 2005 and have Visual Studio Tools for Microsoft Office SE installed. I created a new project using the Outlook addin for Office 2007 and used the following code which I got from MSDN help; Private Sub CreateMailItem() Dim mailItem As Outlook.MailItem = _ Me .CreateItem(Microsoft.Office.Interop.Outlook.OlItemType
  • Why FolderSwitch event doesn't rise up sometimes?
    by Freeson Lee
    2 Replies
    Last post by Freeson Lee
      • Hi The code is Code Block private void ThisAddIn_Startup(object sender, System.EventArgs e) { this.Application.ActiveExplorer().FolderSwitch += new Microsoft.Office.Interop.Outlook.ExplorerEvents_10_FolderSwitchEventHandler(ThisAddIn_FolderSwitch); } If I switch folder to Inbox, the ThisAddIn_FolderSwitch method is invoked. Then later, it won't be
  • need help w/ sumif or countif nesting stmts
    by Ricdik
    1 Replies
    Last post by Dennis Wallentin
      • I've looked over the internet & haven't found a solution that fits my need even after I've applied formulas to suit my spread sheet. Column C Brand 2 1 12 2 1 1 6 1 1 0 Brand 2 1 9 1 1 1 3 1 1 0 Brand 0 0 6 1 0 0 4 1 1 0
  • F5 -> "File already exists"
    by Victor Hadianto
    14 Replies
    Last post by Mike Walker
      • Hi, I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then. Strange tha
  • Saving a copy of an active document
    by Kotyara
    7 Replies
    Last post by Cindy Meister
      • Hi folks, Is there a way to save a document to an arbitrary location without affecting the document object itself Something like ExportAsFixedFormat, but able to handle all the normal saving formats. Document.SaveAs doesn't really work that way, it changes the path/filename/format of the document to reflect the last save. Any ideas Cheers, Alex.
  • AppCheck.exe fails to find Office 2003 installed
    by AndyJump
    3 Replies
    Last post by AndyJump
      • I have an outlook addin that I have created using the VSTO. It works on my machine but when I try and install it on anoher machine (I've only tried the one) for testing it fails saying it can't find a compatable version of Excel. Looking at the installation log (see below) it seems that it only mentions Excel as it's the first list and in fact it can't find Outlook or Word either. Off
  • How to save Excel object for further use?
    by BlackBar
    14 Replies
    Last post by BlackBar
      • Hallo. I'm writing AddIn for Excel 2007 in C#, using VSTO 2005 SE. I'd like to have possibility to use something similar to templates - specially saved Excel objects (for example: a pattern of the table) for further use. For example: I'll create an Excel table which represents information about person (Name, Surname etc.) and I'd like to paste this table in a Worksheet, allow user to fill it and
  • I tried to do it,but it failed.
    by NaamaV
    14 Replies
    Last post by NaamaV
      • Hi, I created my own custom template, and I'm working now on the setup project. but I don't understand how I can cause Word to open all the documents with my template. I need to change the normal.dot How I do it .