Office

Page 390




  • Topics
    Replies
    Last post
  • Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook._Application'
    by Kulvinder
    7 Replies
    Last post by Andrew Cherry [MSFT]
      • Hi, I am using Outlook 2003 professional and getting the "MAPI" Namespace reference using : Microsoft.Office.Tools.Outlook.Application.GetNamespace(String Type) The exception which i am getting is : Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook._Application'. This operation failed because the
  • Regarding opening excel file in C#
    by Asim Patnaik
    2 Replies
    Last post by Asim Patnaik
      • Hi, I use Process.Start to open an excel file from my code. Following is the code: Process xlProcess = Process.Start(fileName); This actually opens the excel file with an existing excel process (if there is any). But what I want is that it should always start a new excel process and open the file in the new process. Is it possible to it this way Regards, Asim.
  • C# COM server visible in Excel "Insert Object..."
    by DAS1108
    9 Replies
    Last post by DAS1108
      • Hi, I want to create an C# COM server which will be visible at "Insert Object" in Excel. I found many examples how to create an C# class and use it from VBA. But what I have to do that I can insert such a C# class within an Excel sheet directly without VBA Of course I need to implement some additional interfaces, but which ones and how in C#. Thanks. Daniel
  • Reading an Excel range into Object(,) - 1 based?
    by Arthlan
    5 Replies
    Last post by Dennis Wallentin
      • Hi, I've been using something I learned (probably here), but don't really understand what's going on. I read ranges into a variable with the following: Dim mValues As Object (,) = _ CType (Globals.Sheet1.Range(Cell(r1, c1), Cell(r2,c2)).Value, Object (,)) Where I use "Cell" to save typing: Private Shared Function Cell( ByVal Row As Integer , ByVal Column A
  • Iterating through Excel Workbooks collection does not pick-up all open workbooks
    by Sergei_SG
    3 Replies
    Last post by Sergei_SG
      • Hi all, Have been trauling the net for the answer but it seems it works for everyone but me... Scenario: 1) open a few Excel workbooks 2) start my C# app that opens a form "MainForm" with a list box "ListOfWB" 3) what I needed is to populate the list box with the names of all open Excel workbooks I've done it tone of times in VBA, but the first
  • Document Name?
    by Blinocac200sx
    14 Replies
    Last post by Scorphg
      • Ok, I want to assign a the name of the currently loaded document to a variable, how would I go about doing this
  • Remove borders from Excel charts using C#
    by becklighter
    14 Replies
    Last post by becklighter
      • I am building an excel file from scratch. this includes charts of data. In this particular case I need to remove the borders from the chart, but it doesn't appear to work correctly. // The next three lines are an attempt to remove the border, the fourth shows that I am controlling the chart ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.LineStyle = Excel.XlLineStyle.xlLineStyleNone;
  • Converting Word into HTML
    by Polly Anna
    3 Replies
    Last post by Polly Anna
      • Hi, I am using the code below to convert my Word document to html. However the wdFormatHTML statement is not supported. I can't seem to find any help on the MS Knowledge Base etc and I would really appreciate assistance on this. Many thanks in advance. Polly Anna Dim strFileName As String Dim objWordApplication As New Word.Application Dim objDocument As New Word
  • Activating next\previous item
    by ArthurTep
    11 Replies
    Last post by ArthurTep
      • Hello, In my project I need to simulate in WinForms behavior one can observe in Inspectors window. Once you open inspector on a particular item. In the top left corner of the inspector there are two arrows allowing moving the inspector the next\previous item in the folder according to the view sort. Searching hard as I can, I haven't found anything that can give me the same func
  • Excel Edit Delete Disabled
    by Martin Danner
    12 Replies
    Last post by Hot Key
      • I created an Excel Workbook project using Visual Studio and VSTO. This project uses the ListObject control bound to a DataTable to display and update data in SQL Server 2000 database. When deployed to the user's workstation, this application has an annoying habit of disabling the Delete item on the Edit menu, preventing the user from deleting columns, rows or cells. Actually this is more than a
  • Outlook undo statck
    by DoWang
    4 Replies
    Last post by DoWang
      • Does Outlook allow us to maniputalte the Undo stack of HTML Editor Anything like "ClearUndoStack()" or "UndoLastOperation()"
  • Outlook: New Massage custom UI
    by Sidon
    1 Replies
    Last post by Sue Mosher - Outlook MVP
      • Is it possible, and if haw can I change UI of NewMessage window What I need is to add come controls under "subject" TextBox. Witch objects i have to use for that Thanks
  • Installation woes when running Office 2007
    by Bill Sempf
    2 Replies
    Last post by Bill Sempf
      • So I have a new Tablet PC with Visual Studio 2005, Office 2007 and Windows XP Tablet Edition. I am going to work on the new VSTO book with it. VSTO 2005 SE installs fine, but there are no document projects. So I tried to install VSTO 2005 First Edition, but it requires Office 2003 SP1 to run. I don't WANNA install Office 2003. Is there a way to get just VSTO Addins and Documents for 2007 on a
  • How to update the manifest?
    by Malleswar
    2 Replies
    Last post by Malleswar
      • HI, To deploy my word, powerpoint, excel addin projects(added few buttons and functionality through that), I am using the following link: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2032816&SiteID=1 According to this link we need to update the manifest which is document level. VSTO SE provides only Application level(Ad- ins) but not document level customizations. For this VSTO ( w
  • BUG? Data Island cache not updating immediately
    by DancesWithBamboo
    8 Replies
    Last post by DancesWithBamboo
      • I have 2 Word documents that have a parent-child relationship to each other. Document B pulls a string from the data island inside of Document A using the ServerDocument (client side...no web or server here). Both documents are open at the same time. What happens is that when I update the cached string field in A, B doesn't see the updated value until after A has been closed, reopened, and then sa
  • Problem Saving Attachment's with the same (sent) file name. How to clear outlook internet temporary files?
    by Mike-T
    2 Replies
    Last post by Mike-T
      • Hi, I am sent an update file from a third party using email. They are not able to use FTP, and I am one of many users so their side of the system cannot be changed. The update file is attached and called update.txt, an outlook rule places the emails in . There is a maximum size that file can be (on the third parties side) which is about 10K. So if there are 300,000 updated items to send t
  • How I Can Add My Custom Template to Normal.dot?
    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 .
  • Enumerating merged cells in MSWord automation
    by dzeaman
    2 Replies
    Last post by Cindy Meister
      • Hello there! Explain me please how should I enumerate all cells in a MSWord's table (using automation of course). There're merged cells in a table, something like that: http://esb.toxahost.ru/word/table.jpg If I try to get access to the cell (2,1), I have an exception (cell doesn't exist because it's merged with the upper one). If I try to get (1,1), it looks like it's not a part of a merged
  • Excel Tools and formatting
    by Arthlan
    2 Replies
    Last post by Arthlan
      • Hi, Forgive me for posting this in 2 areas -- I had already posted this to a "d iscussions in vsnet.vstools.office ." However that seems to be way less active than this. I don't know if my Visual Studio has always behaved this way, I don't think so. I have an xls sheet visible, and the menu items at the top of VS2005 has "Tools". Within "tools" is "Microsof
  • VSTO Workbook Events
    by AdriaanDavel
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I am using VSTO 3 (VS 2008 Beta 2) to extend functionality in Excel. I use the Microsoft.Office.Interop.Excel._Application.ActiveWorkbook.NewSheet event to respond to new sheets being added to the workbook, and need events for when a sheet is renamed or deleted from the workbook but cannot find any, can anybody help pls!
  • VSTO Eye for the Non Developer Guy
    by OmegaMan
    2 Replies
    Last post by OmegaMan
      • If one were to describe the benefits of the differing VSTO projects to a managerial staff that may have no clue to what a VSTO application is verses an old style add-in...is there a good link to provide the uninitiated, the end-user benefits of VSTO created applications
  • Outlook.AppointmentItem.Conflicts - Problem
    by Iram
    14 Replies
    Last post by Iram
      • Hi, I'm writing an AddIn Outlook application, that should create new Calendar instance. In this new Calendar I need to check each change in each item if it has any conflicts with other Calendar item. I tried to use Outlook.AppointmentItem.Conflicts member but its count property always equal to 0. What am I doing wrong Thanks, Iram.
  • Is this possible with VSTO and VS 2005??
    by Neal Hudson
    6 Replies
    Last post by John R. Durant - MSFT
      • Hi The problem I am facing is to take a Word Document, insert a new 1st page (which will be another Word Document with a single page), and save the new version as a PDF. I have found a solution using VS 2005 and Office automation, by programmatically opening Word 2007, using the Range.InsertFile method to insert the new document, and then using the new WdSaveFormat.wdFormatPDF to save as a P
  • how to enable excel add-in installer in vsto 2005 if disabled
    by parm
    2 Replies
    Last post by Darryn Lavery -- MSFT
      • hi i have create a excel add-in for office 2003 using vsto 2005 SE. But after builting and running application i am not getting the installer or any setup. plzz help me out of it.
  • First steps in VSTO
    by Gilad Asaf
    3 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hello, I'm a VBA developer and I had some experience with C# (and java if it helps) I want to check the VSTO - but I don't know who (without the studio environment) I need to know if it is possible to develop VSTO for Excel 2003 without visual studio or other products. I wonder if it's possible to create code in notepad, compile it somehow and make its functionality