Office

Page 248




  • Topics
    Replies
    Last post
  • Draggable ListBox - Excel
    by Arthlan
    6 Replies
    Last post by Arthlan
      • Hi, Can I create a ListBox, display it on an Excel sheet and let my users drag it around That is, not drag a value from it, but drag the entire ListBox. I'd appreciate any help, even a "yes, but it's really really hard." Thanks
  • Security problem Word 2007 add-in
    by EagleWizard
    6 Replies
    Last post by EagleWizard
      • In the add-in itself I use reflection. An other programmer can give me a DLL file with actions (functions) and with the class, namespace and the path of the DLL I can use these functions in my add-in. I tested everything in a windows application and it worked perfect. After that I tried to use the same code in my Word add-in but I got a Security error. Here is the code where I had the problem:
  • VSTO Outlook Addin Help
    by 100011
    13 Replies
    Last post by Sue Mosher - Outlook MVP
      • I already asked this question but nobody answered it. If nobody knows the answer please let me know and I will search for an alternate solution. I am trying to create an AddIn for Outlook. The AddIn is used to auto populate the "To..., Cc..., and Bcc..." on a new message from data I have stored in a database. Does anybody know how to create or overload an event handler for the t
  • Communication between Add in and Smart Tag in Office 2007
    by Kostadin Georgiev
    3 Replies
    Last post by Kostadin Georgiev
      • Hello, I have developed a custom smart tag dll for Office 2007. I've registered it in the win registry and the Office 2007 applications succesfully load it. But how can i access the recognizer of my smart tag in the Add-In that i'm developing (I need to set the recognized terms in my Add-In) It is not in the Application.SmartTagRecognizers property. Does this mean that custom smart tag recogniz
  • Adding pages to document based on the same template
    by Christian Sparre
    7 Replies
    Last post by waterseller
      • Hello I have a simple single page template for a letter that I fill out using a simple C# application. But how do I make multiple pages of that template in the same document, eg. adding pages to a "Microsoft.Office.Interop.Word.Document" document for each recipient. The letters will never be more than a page long. What I'm trying to accomplish is beeing able to make severel letters from
  • Deploying my VSTO-project.
    by Zappke
    12 Replies
    Last post by Zappke
      • Hi! My problem is as follows: I had to upgrade a VB6-project to VB.Net, and while I was at it, make it so that it would be more pretty (all this is an Office Word-add-in). So I did just that on my local PC, I changed the forms to CustomTaskPanes and such, all looking very nice if I may say so myself First problem came in the form of the DLL's that were used: there was a COM-dll that was made way
  • How to make a Form Region default to an Outlook-2007 folder
    by Rama Krishna rao
    2 Replies
    Last post by Rama Krishna rao
      • Hi, I have created a form region(.ofs). I have couple of questions. 1> How to publish form region programmatically 2> How to make this form region default to a folder programmatically Thanks. Rama
  • Developing an Addin for Excel - Problem Debugging
    by radimt
    1 Replies
    Last post by Andrew Cherry [MSFT]
      • Hi, I am writing an Addin for Excel which will create menu and do some other good stuff. I am using VST 2005 version 2.0.50727. The problem is that when I try to debug the code I wrote, I can't get the process to enter the OnConnect event. So it starts Excel (as I have specified Excel.exe as "Start external program" option) and then does nothing. How can I get this to laod my addin once
  • Single Addin for Word 2003 and 2007 ?
    by Kuroczyd
    2 Replies
    Last post by Kuroczyd
      • Hi, During 3 days I am trying to find some information or sample about using the same addin in office 2003 and 2007 : I know that the UI is different (CommanBar for 2003 and Ribbons for 2007) but can the same addin be used for both Word 2003 and 2007 if the right interfaces are implemented Thanks Daniel
  • Why all addins try connect to crl.microsoft.com at start?
    by FTom
    1 Replies
    Last post by Ji Zhou 每 MSFT
      • I try install VSTOR addins to the computers which can't access to the internet. All addins wait for something at start. I discover that addins access to the crl.microsoft.com. Is possible turn off this feature
  • Outlook Exchange server address
    by ssundan
    4 Replies
    Last post by Ji Zhou 每 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
  • Exception from HRESULT: 0x800A03EC. at at Microsoft.Office.Interop.Excel.WorkbookClass.get_VBProject()
    by Siddhartha Dutta
    2 Replies
    Last post by homedream
      • Hi, I am trying to create a excel macro programatically from VS .Net 2003 (C#). I followed the MSDN KB article at http://support.microsoft.com/ kbid=303872 . However everytime the program executes the following line of code, it behaves strangely. Code Line: objModule = objNewBook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); Everytime the code tries to exec
  • Copy() method of the Word::Range will throw an exception in the Outlook07
    by Peter.Zhao
    1 Replies
    Last post by Ji Zhou 每 MSFT
      • In the Outlook07, word docment is the default editor for the emailitem. I get the Word:: Document property by using Inspector->GetWordEditor(). After some operations, I got a Word::Range from the Word:: Document(), then I called the Copy() method of this range, but it throw an _com_error exception says "CXX0030: Error: expression cannot be evaluated". And I also trie
  • How to create Excel HostControl from code behind Custom Control on TaskPane?
    by MaratYa
    8 Replies
    Last post by MaratYa
      • In VSTO Excel document level application I need to add NamedRange controls on various worksheets. All examples I found show the creation of NamedRange from Worksheet_startup event like this: Dim textInCell As Microsoft.Office.Tools.Excel.NamedRange textInCell = Me.Controls.AddNamedRange(Me.Range("A1"), "cellText") But I cannot seem to be able to create a named ran
  • using Cell object in C#
    by linkgoron
    13 Replies
    Last post by Ji Zhou 每 MSFT
      • Hi, I need some help translating the C# cell object into something I can use in my program. What I mean is, I can read the files using Ws.cell[x,y], and I can copy them from one Excel sheet to another, but I can't use the values in the Cell object. I tried conversions and all I get is system __COM object (or something similar). Is there any way to convert the info that's saved in the Cel
  • Word Automation: Inserting AutoText in a document fails
    by deyan.ginev
    3 Replies
    Last post by Cindy Meister
      • Hello, guys! I am writing a wrapper class library for some of the main objects of the Word Automation API and need to provide some functionality to the user to display the current page number in a document at a specific location on the page. Using the Macros Tools in Word, I found out how it is done in VBA and managed to translate it into C# code: //Getting th
  • Programming Comments in Excel 2003
    by Brando15
    1 Replies
    Last post by Ji Zhou 每 MSFT
      • Hello, I am programming a userform to input and edit records in a spreadsheet. I have a couple of textboxes in the form that I am using to add comment boxes to certain cells. I am trying to find a way to set the comment boxes format to automatic size within the userform's code. This way long comments will be entirely visible when the mouse hovers over the comment. Any help or suggest
  • Add transparent icon to workbook programmatically
    by volker.katz
    6 Replies
    Last post by volker.katz
      • Hi, I want to add an icon with an transparent background programmatically. I can do that by clicking in Excel - so it is possible. Here is my code: Excel.Shape shape = sheet.Shapes.AddOLEObject("Forms.Image.1", missing,missing,missing,missing,missing,string.Empty,dleft, dtop, width, heigt); Excel.OLEObject oleObj = Excel.OLEObject)sheet.OLEObjects(shape.Name); MSForms.
  • 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.
  • MailItem.Send() progress
    by MuscleHead
    8 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi, I'm using VSTO 2005 in Outlook 2007. Is there a way to monitor progress after calling MailItem.Send() It usually works fine, but today for some reason it seems like my code called Send(), the email was never sent, and no exception was thrown. Can I monitor progress, or find out if an error occured
  • Not refreshed items
    by Janni Kajbrink
    5 Replies
    Last post by X4U
      • Hi, I'm developing an Outlook 2003 add-in with VSTO Second Edition. I'm having trouble with not getting the same data from appointments that are showed in the Outlook UI. I have the following example: Private WithEvents m_oCalendarItems As MsOutlook.Items Private Sub ThisAddIn_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup m_oCalendarItems =
  • Where is my Access class
    by Maarten Zaagman
    4 Replies
    Last post by thorkia
      • Hello, I'm trying to develop a program for automising ms Access. I'm trying to using the office PIA for this. I have added the Microsoft Access 11.0 Object Library to my project references(including core). But i get an error when trying the following: Access.Application test = new Access.Application(); This is the error i'm getting: C:\ReportCollector\Form1.cs(144): The type or names
  • Creating a COM compatible class in C#
    by nic28
    4 Replies
    Last post by nic28
      • Hello everyone, I'm trying to build a .NET class with C# which would be used in Excel VBA. I read in the O'Reilly book "Programming Excel with VBA and .NET" that, in order to do this, you had to click on Project->Add Class... and then select "COM Class". However, "COM Class" is not one of my options in that menu. I'm using Visual Studio 2003, so is
  • Excel: getting cells from named range using OpenOffice XML
    by AndersR
    1 Replies
    Last post by Cindy Meister
      • Hi, i want to retrieve cell formats from a range of cells using OpenOffice XML. i have managed to get out the named range from DefinedName element in Workbook.xml, but whats the best way to get to the cells from here the value stored in DefinedName.InnerText is of syntax sheet1!$A$3 N$12 but what would be the best way to extract the cells from the sheet thx AndersR
  • Debugging Problem
    by ssouki
    3 Replies
    Last post by Mike Walker
      • Did anyone encounter problems in Debugging a VSTO application I am working with Excel VSTO and everytime I start a debug session it only lasts for few seconds or several steps and the VS 2005 restarts. WEIRD...... Pls help.....