Office

Page 210




  • Topics
    Replies
    Last post
  • Format excel sheet using c#
    by Shantanu Sen
    3 Replies
    Last post by Andrew Whitechapel - MSFT
      • Dear all I have a project which fetch data from HTML web page and writes it into a excel sheet . I have office 2000 installed on my PC which uses Microsoft Excel 9.0 Object Library right now i am able to write the data in a excel sheet , but i am not able to format the sheet for some unwanted entry using the library. Please provide some resolution shantanu
  • Installing VSTO
    by dclements
    4 Replies
    Last post by dclements
      • Where can I find information for installing and setting up VSTO I already have Visual Studio and Office 2003 installed and I need to figure out how I can setup Visual Studio so that I use VSTO functionality.
  • 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
  • get the selection range in excel with vsto
    by lucky027
    4 Replies
    Last post by Cindy Meister
      • Hi!! I have a simple answer, but I don¡¯t know how to resolve it... I only need to get the selection range in a excel sheet, when I press a button in an vsto action pane... how I can to do it thanks!
  • Retrieving data from SQL Server to Excel
    by Everardo Gentil
    3 Replies
    Last post by Christa Carpentiere - MSFT
      • I'm developing a solution to creat pivot tables in a Excel's workbook from data in Sql Server 2005. When I run the project in my local machine (Windows XP Pro Portuguese with Office 2007 English) it returns the workbook with the pivot table desired. However, in the development machine (Windows Server 2003 English with Office 2007 Portuguese) the program returns the follow message: "Erro de si
  • Help ! save a object into excel
    by y.shao
    3 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I am using c# to develop a excel add-in I have an object in the excel session, and I would like to save this object into excel, so that users can retrieve the object contents back next time they open the excel document. I have tried to serialize the object, and add the serialized file as an OLEObject into excel, but I am having problems with loading the object type back Could anyone give me so
  • Creating new Word object - COMexception error
    by bogorman
    6 Replies
    Last post by bogorman
      • Am a complete newcomer to VS2005. I have a reasonable knowledge of Access Visual Basic. Am trying to develop a very simple Windows application for use on local machines (not on the server). I have a simple form with the following coding: Imports System.IO Imports Microsoft .Office.Interop.Word Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
  • Can't get the add-in work in excel
    by Maximus
    6 Replies
    Last post by Maximus
      • Hi all, [sorry for double posting] I'm newbie to C# (I'm a Java developer) and I wonder if anyone can assist on this one. I'm trying to implement an add-in to excel. I tried the example given at: http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx all worked well but one minor issue: I can't get this - AutomationAddin.MyFunction on the insert Function Dialog. * yes, I have it in my
  • call a form from word (VSTO2005)
    by ClaudiaHelpOnVSTO
    4 Replies
    Last post by ClaudiaHelpOnVSTO
      • Hi, I would like to open a popup window (just a form/application containing a web browser) when a user clicks on a button within the word document. Can you provide me with a code example to get me started I managed to do it from the Actionpane... but it does not work within the document ! (using VSTO 2005 and Word 2003) Thanks! Claudia
  • Executing default SmartTag Action Menu Item programatically...
    by Syed Raza
    3 Replies
    Last post by Cindy Meister
      • Hi all, From the available default action menu items, how can we execute 'Remove This Smart Tag' action item programatically in c# If we check the doc.SmartTags.get_Item( ref index).SmartTagActions.Count property, it returns the custom action items count. Not includes the default action items. Looking for a way to execute the first default action item. Thanks in advance.
  • VSTO Outlook 2003 Add-in Deployment problems
    by jdrawmer
    13 Replies
    Last post by jdrawmer
      • I've had a lovely little add-in now working on my machine for a while, and yet I haven't been able to deploy it successfully, not even on my own machine once. The program works absolutely perfectly on my machine when debugging and running through Visual Studio, but when deployment comes, the common error "Not loaded. A runtime error occurred during the loading of the COM Add-in" occur
  • Can't use my add in with word 2003
    by belote
    8 Replies
    Last post by belote
      • Hello I've created a word add-in with vsto by selecting word 2003 add-in. When I run it in debug in visual studio, it works. So I run the setup, and that creates me a dll. I open the template where I want the add-in runs But in word, in tools -> Templates and Add-Ins, only *.wll files are accepted. I've tried to rename the dll in wll, but it doesn't work.
  • VSTO 2005 SE, Office 2007, and ... Visio for EA version?
    by lex3001
    3 Replies
    Last post by Ji Zhou ¨C MSFT
      • Ok... I am setting up a new Vista x64 workstation for development. I am going to install VSTO 2005 SE which wants me to have just one version of office installed. That is going to be Office 2007. However, I also want to install and use Visio for Enterprise Architects off of the Visual Studio Team System 2005 Developer Edition DVD... I assume that is going to be Visio 11 (Office 2003)
  • No service pack for VSTO 2005?
    by ccassino
    5 Replies
    Last post by Gabi10
      • Using VSTO 2005. We installed the SP1 Beta, installed no problem. The RTM verison of SP1 for Visual Studio 2005 will not install on VSTO 2005. VSTO is not listed as having an SP release, only Team Ed. and Prof. Was there no SP released for VSTO Does anyone kow any reason for this Especially since we were able to install the beta versionit does not make much sense. Help Thanks
  • Cannot Cast COMAddIn to Specified Interface
    by Jacob Shafer
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Following a blog from Andrew Whitechapel ( http://blogs.msdn.com/andreww/archive/2007/01/15/vsto-add-ins-comaddins-and-requestcomaddinautomationservice.aspx ) I tried to create an Excel Addin with a Com registered utility class that I could call from a windows form application. Instead of having the interface inside of the AddIn, I moved it to a new project that is marked as ComVisible and set Reg
  • Can't install VSTO 2005 SE on Office 2007
    by Fraser Drysdale
    5 Replies
    Last post by JimCrist
      • What this doesn't address is that one can't install the VSTO SE package without already having the first version installed. This requires an Office 2003 SP1 product. The only Office 2003 item we used was Outlook, but since that was part of our Exchange 2003 license (even though it included all the secondary office appliations - ie - scanning, etc.), it won't allow us to install the original VSTO 2
  • Programmatically creating a new outlook email message containing tables
    by michael447887
    1 Replies
    Last post by michael_mathys
      • I am writing an application using VB.NET in VS 2003 that needs to programmatically create a new email message in Outlook 2003.  The email needs to include tables containing data from a database.  How do I create the body of the email   I found information about creating Word documents which would work perfectly for my needs if I could make it work in Outlook.  http://support.mi
  • Outlook AdvancedSearch - Finding emails using categories
    by justin tighe
    3 Replies
    Last post by Sue Mosher - Outlook MVP
      • I am building an add-in to outlook where one of the features will be to filter the list of emails based on one or more categories assigned to the email. I am trying to use the AdvancedSearch to build a search folder, but the code I am using does not work - I get an Operation Failed message. The code I am using (which is run from a command bar button) is below: The help files are vague on wha
  • VSTO SE Runtime install failed
    by RIManning
    4 Replies
    Last post by RIManning
      • Hi there - I've got vsto 2005. When I try to install SE the installation of the runtime fails. I've looked through the installer log and the only thing that looks remotely suspicious is the following: ExpressUI: ISetupManager::GetGlobalCustomProperty() failed to find global prop in CProgressPage::RunningComponent() ExpressUI: {4F8791EE-486F-44B5-952B-F28F9FD58BD0} This entry shows up mult
  • MAPIFolder
    by ANGanley MCSD
    4 Replies
    Last post by ANGanley
      • Help Please. I have the following code. basically i want to access outlook contacts. Imports Otl = Microsoft.Office.Interop.Outlook Private Sub AccessContacts( ByVal findLastName As String ) Dim Outlook As New Otl.Application Dim foldercontacts As Otl.MAPIFolder = CType (Outlook.CreateItem(Microsoft.Office.Interop.Outlook. OlItemType .olMailItem
  • when i want to forward a MailItem, how can i use olRuleActionForwardAsAttachme?
    by spacestar120
    9 Replies
    Last post by Sue Mosher - Outlook MVP
      • When i want to forward a MailItem, i want to use ForwardAsAttachment, how can i use olRuleActionForwardAsAttachme Any one know it
  • VSTO Add-in for Word 2003
    by Jonathan566279
    3 Replies
    Last post by Jonathan
      • Hello, I got a new problem. In this time I try to install VSTO 2005 SE but it doesn't work! I tried to install it directly on my current config but I got this message : Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System can only be installed on a machine with the corresponding Visual Studio localized edition. Please install the matching Visual Studio 2005 localized edition and
  • Accessing Excel ComboBox values programmatically
    by kroyce
    8 Replies
    Last post by kroyce
      • All, I have created an Excel add-in that loads information from Microsoft Project Data Server into a spreadsheet. For each row of data added to spreadsheet, I add a combobox that is populated with several options to choose from (there is a different default value for each combobox). I use the following code snippet to add the comboboxes to my spreadsheet: Microsoft.Office.Tools.Excel.Control
  • How to consume a WCF service ?
    by Serge Calderara
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Dear all, I have build a WCF service which is in charge to return statistical data to any client... my service is hosted under WAS and accessible through TCP. I need to make a simple internal conay demo to show my co workers and boss about that my Service can alos be consume through an excell sheet or word.. I simply would like to call a simple function in my service which retu
  • app.config connectionStrings
    by cb3431
    5 Replies
    Last post by Dennis Wallentin
      • I have created a Shared Add-in project. To this solution I have added a User Control project and a WPF User Control project. I am hosting the WPF control in the User Control. I am trying to get a connectionString from the app.config file, but it acts like the app.config file is not even there. connString = ConfigurationManager.ConnectionStrings( "sql" ).ConnectionString