Office

Page 189




  • Topics
    Replies
    Last post
  • Microsoft Office
    by hassan561594
    1 Replies
    Last post by Steve Hansen
      • I am using Windows XP Home Edition. I am using Microsoft Office 2003 Profession Edition. 2 weeks ago, some of office files have been corrupted; I don't know how it happened. I tried to repair it via using Office CD-ROM, but no vain. When I click on any program of office like word, excel, a dialog box opens which has message preparing to install and afterwards, message box displays short error. Whe
  • Large Strings (Range.InsertXML)
    by Word Dev
    8 Replies
    Last post by Cindy Meister
      • Hi I am currently developing a reporting application in Word. This report can be quite large. I have recently come accross and error which I fell is a limitation in the VSTO for word. Perhaps there is a another way I can approach this problem. Issue: I have a large datatable (> 11000 rows), i write this to an Xml memory stream and transform it into wordml using an xsl file. (all good so far).
  • Office 2003 or 2007
    by GuyLowndes
    7 Replies
    Last post by Westman
      • I'm looking to upgrade a single PC that has Office XP installed so it can use an application written using Visual Studio 2005 Tools for the Microsoft Office System. I obviously want to get the most current version there is but I'm not sure if there are any implications on using Office 2007 or should I stick to Office 2003 for now
  • vsto vb.net need table in table or wrap rows?
    by Grant60601
    3 Replies
    Last post by Cindy Meister
      • I am building a table and am getting data for the table from sqlserver. The columns that are being returned need to be wrapped into a second row. I was thinking of the folloing logic. Create table 1, loop through data, create table with 2 rows, fill table 2 with data for the record, next. Is this the best approach or is their a method that would wrap the columns into the next column
  • How to read excel cell styles?
    by Xfolder
    4 Replies
    Last post by vikaaas
      • Hi! Could please anyone show an example on how to go through all cells and read their style. (font size, color etc.) in VB.NET thank you
  • VSTO Excel COM AddIn Event is only fired once
    by Steven Hawkes
    1 Replies
    Last post by Steven Hawkes
      • I have written a Com AddIn which on startup creates an entrz in the main menu bar and adds a MenuBarItem and an associated event. When I run the AddIn in Microsoft Excel, I can click the Menu Item and the event fires fine the first time but subsequent attempts to click the Menu Item results in the click callback handler not firing. To get it to fire again, Excel must be restarted. Has anz
  • Form Region display issue
    by Rafael1119
    14 Replies
    Last post by Rafael1119
      • All, Is it a known issue that the Form Region text boxes and labels cut off the text and change the font size automatically Has anyone figured out a way to make the form regions look exactly as they did when you designed them Thanks, Rafael
  • Retrieve current document path
    by Freeko
    14 Replies
    Last post by Xm3KHs
      • Hey guys, although it isn't strictly VSTO-related question I'm sure you'll know hot to do it and help me So, I wrote simple COM add-in for word, excel and powerpoint. One of the functions of this add-in would be to retrieve current document path / location (E.G: "C:/Users/USername/Documents/presentation.ppt".) and then do something with it. Is there a method that would work for all pro
  • Howto set focus on newly opened word document (W 2003)
    by Ilya Cherkasov
    5 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi all! I have an issue with opened documents. When I do this: FileInfo documentFile = _tempSaver . GetFromEdition(e . Data); string documentPath = documentFile . FullName; object boxedDocumentPath = ( object )documentPath; object visible = ( object ) true ; Microsoft . Office . Interop . Word . Document document = _thisAddIn . Application .
  • Populating word document with data in .net application?
    by Job Lot
    2 Replies
    Last post by ddm
      • I need to create a Contract of Sale document in word which gets populated with client details from a .net application. How can I populate word document from a .net application and then open the document I am using office 2003, VS2005 and SQL Server 2005 Thanks
  • What would cause Outlook to throw exception during instantiatiation of ApplicationClass?
    by mdpowersslo
    2 Replies
    Last post by mdpowersslo
      • We have an application that starts an Outlook session with the code OutlookApplication = new ApplicationClass(); Normally this works ... but one user is reporting getting a message that we put up when this code throws an exception. This is consistent on one machine in the user's network, but does not occur on any others. Any ideas on what could be causing this other than a
  • Converting Office documents to PDF using csharp
    by mrleokarthik
    1 Replies
    Last post by Cindy Meister
      • hi, Please get me code snippet for converting excel and powerpoint document into pdf using csharp . I have installed VSTO 2005 Second Edition.exe as well as Plugin SaveAsPDFandXPS thanks in advance
  • Handling optional XML-Nodes
    by blindi
    4 Replies
    Last post by blindi
      • I have a Word template VSTO2005 solution with an extensive XML-Schema. Many nodes are optional. So one document created with the template contains a node and another not. If I use for example an eventhandler for ThisDocument.MyOptionalNode.ContextLeave, documents without the node "MyOptionalNode" will no longer start with the solution, stating the object MyOptional Node doesn't exists
  • appending data to an excel sheet
    by sounddoc
    3 Replies
    Last post by Cindy Meister
      • Hi all, After searching around for a couple hours i'm finding it hard to believe that there's not a lot more info on what would seem like a simple thing: appending data (row) to an existing excel sheet in vb.net Basically I have an excel sheet that I want to add a row of data (with about 6 cells) from my app each time it's run. is there a method built in to append to existing rows, o
  • setting default message format to rich text in outlook 2003 using C#
    by Ubersnack
    3 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi, I wrote an application a few months ago that programmatically set the signature for outgoing emails (using some of the code from this forum, thanks!) and setting the signature works perfectly... However, the company have their email signature in rich text format, and do not want anyone sending html emails. I have had a try at it, the closest thing I have found is in Microsoft.Office.Inte
  • Excel Visual Studio Design Time Adapter Add-in
    by Hbomb624
    11 Replies
    Last post by robotjesus
      • After installing VSTO and VSTO SE, when I try to create a new Excel VSTO App I get this message: "Project cannot be created because the application add-in is not working correctly and might jave been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or About Microsoft Office Excel, and then click Disabled Items.
  • Exporting data from Excel
    by dclements
    1 Replies
    Last post by Cindy Meister
      • I've been assigned a task to write an Visual Basic .Net application that read data from an existing excel file and uploads the data to an SQL Server. The excel file itself is not a VSTO application, nor does it use VBA code. I know I can save an Excel file as a tab delimited file, import that file into an access database, and then use the data in the access database updata the file, but this is
  • Outlook AdvancedSearch DASL
    by sjb500
    3 Replies
    Last post by dkonline
      • I've been developing an Outlook add-in using the AdvancedSearch method and all was going well until I tried to use the DASL filter " http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/CompanyCheck " IS NULL where the CompanyCheck is a custom text field that may or may not contain some text. Everytime I run this search programmatically it returns zer
  • Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003
    by Bill Joe
    9 Replies
    Last post by Rob van Meeuwen
      • I am developing a VB.Net application with VS 2005 that opens an Excel workbook and populates the worksheet with data. I started developing the application with Office 2007 installed on my Vista OS, but after I discovered that it won't run on a system with Office 2003, I uninstalled Office 2007 and installed Office 2003. I reset the reference in .Net to the Microsoft Excel 11.0 Object Library. The
  • Issue creating different first page in word doc
    by Job Lot
    2 Replies
    Last post by Job Lot
      • I need a different first page in my word document. First page should have image in the header and a line across the page in the footer. I am using the following code but it does not show me the line on the first page. When I press Ctrl + Enter to create a new page it shows the line on the new page. If I change the code to show some image in the footer instead of a line it works alrite. What is goi
  • How to get addin install to work for non-admin users?
    by PlanetWilson
    5 Replies
    Last post by Darryn Lavery -- MSFT
      • I have built an installer for my VSTO addin which works fine under Outlook 2003 and 2007. I have code whcih sets the CAS for my add-in so it will run. The problem is that my installer won't run unless the user running it has admin privileges on the box. It displays an error saying you have to be an admin It installs on a per user basis as you can't get the VSTO plugins to install for all user
  • Add-in startup problem
    by KornelK
    5 Replies
    Last post by Dennis Wallentin
      • Hey, I've written a very basic add-in for Excel 2003, using VSTO 2005 SE in Visual Studio 2005. No the problem is, when I launch the add-in via "Run" or "Run without debugging" everything works fine, Excel starts, but when I launch another Excel instance via menu Start, the add-in will not load! What's wrong What is more, when I close both Excel apps, and start a new one from m
  • VSTO over VBA
    by Muralidhar M S
    12 Replies
    Last post by Cindy Meister
      • We have hundreds of Excel tools to automate. What makes VSTO better than VBA to automate Excel Getting Visual Studio or the framework installed on user machines is not a problem.
  • Help with word document(segments or delete)
    by Lobotomybeats
    2 Replies
    Last post by Mohit Gupta - MSFT
      • Hi, I have been searching the internet for help but cant find any. I am trying to create a word-document from my C#-application. I have several different templates that I print info on and use to create documents with. But now I have this new document that needs a bit more logic. Depending on some criterias I need the document-template to look a certain way (some sections should be left out). S
  • Add Control
    by acfalcon2001
    2 Replies
    Last post by Peter de Jong
      • I am adding checkboxes (Microsoft.Office.Tools.Excel.Controls.Checkbox) to an Excel spreadsheet at runtime. They all show up correctly, but you can't check any of them. I have tried it with the sheet protected and unprotected. Below is a copy of the code..... this.Application.Interactive = false; this.Application.ScreenUpdating = false; for(int i = 5;i < this.List2.TotalsRowRange.R