Office

Page 90




  • Topics
    Replies
    Last post
  • add-in doesn't load when launching using new excel.application
    by Denis Pitcher
    5 Replies
    Last post by Denis BDA
      • When launching excel via interop, I've noted that the addins don't appear to load. Dim xlsApp As Microsoft.Office.Interop.Excel.Application xlsApp = New Microsoft.Office.Interop.Excel.Application xlsApp.Visible = True Does anyone have any idea why and how to solve it Otherwise, I need to figure out how to load excel via System.Diagnositics.Process.Start() where I can pass it
  • embeding data into word file
    by Job Lot
    10 Replies
    Last post by Ji Zhou ¨C MSFT
      • Sorry if this is not the right place for this question. I couldn't find the right forum!!! How can I dynamically embed data from SQL Server into a word document I have a Contract of Sale document in word format that I need to automate so that details from the database (e.g. sale date, client name, contact details etc) are dynamically added to this word document. I haven¡¯t done anything lik
  • VSTO 2005 & 2005 SE installs
    by CaptainNemo
    2 Replies
    Last post by CaptainNemo
      • Hi, I am running VS 2005 Professional and MS Office 2003. When I install VSTO 2005, Visual Studio contains the project templates for Excel codebehind programming with C# but does not provide any project templates for Excel Add-Ins. So I then installed VSTO 2005-SE, now I can create projects for Excel Add-ins using C#, but now there are no options to create Excel code-behinds with C#. I ne
  • Keyboard shortcuts in ToolStripMenuItem in Excel Action Pane
    by Shaun Logan
    3 Replies
    Last post by Scoober
      • My question is about keyboard shortcuts failing to work as expected in an Action Pane. I have a document level solution for Excel 2003 using VSTO (C#). In my ActionPane, I have a System.Windows.Forms.MenuStrip that contains several ToolStripMenuItems which have keyboard shortcut attributes defined. For example, there is a "File" menuitem that has a child menuitem "Publish" t
  • Excel menu items not available in VS IDE
    by Molon Labe
    2 Replies
    Last post by Molon Labe
      • Context: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional Microsoft Visual Basic 2005 77617-168-7076001-41239 Microsoft Visual Studio Tools for Office 77617-168-7076001-41239 Visual Studio 2005 Tools for Office Second Edition 77617-168-7076001-41239 Security Update for Microsoft Visual Studio
  • Have microsoft provided any API to develop Office Communicator?
    by nice_boy_super
    3 Replies
    Last post by Douglas H. Troy
      • I want to add some personal function in the Office Communicator. Seems like the tab function in msn live. Anyone know where can i get this information Thanks, Raymond
  • Multi User Model in Visio
    by sarathrs
    1 Replies
    Last post by Cindy Meister
      • Hi, Can we have multi users for one single Visio Application.I mean Visio will be installed in Server and any number of clients can connect and use the Application installed in the server.Actually we want to invoke Visio application remotely using Program Id.Is there any installation procedure to change Program ID so that we can access Application remotely using new Program ID sar
  • Modifying Commandtext for workbookconnection runtime Excel 2007
    by Erik Svensen
    3 Replies
    Last post by Dennis Wallentin
      • I'm trying to modify a SQL string runtime in Excel 2007. I keep getting a runtime 1004 "Application defined or object-defined error". I have one pivotcache in my workbook which is being used in 4 different pivottables. I connect to a DB2 database. First I tried set pvc = Activeworkbook.Pivotcaches(1).WorkbookConnection pvc.OdbcConnection.Commandtext = vba.Replace(pvc.Od
  • how to create a new Tools.Word.Document object?
    by Noah1212
    2 Replies
    Last post by Geoff Darst - MSFT
      • Hi Cindy, Thank you for your repply. There is another question: If I already have a ThisDocument class in a project, can I get its instance by passing a IRuntimeServiceProvider object to its constructor in another project If it is possible, what the IRuntimeServiceProvider is How can I get it I wrote a new class which implemented the interface, and return null in the GetService() met
  • Have microsoft provided any API to develop Office Communicator?
    by nice_boy_super
    3 Replies
    Last post by Douglas H. Troy
      • I want to add some personal function in the Office Communicator. Seems like the tab function in msn live. Anyone know where can i get this information Thanks, Raymond
  • ASP.NET Mail Merge with Office 2007
    by boriscb
    1 Replies
    Last post by Cindy Meister
      • Hi, I have an ASP.NET application running in an Intranet. I can sucessfully do a Mail Merge with Office 2003 while in the Visual Studio environment and it launches the merged document successfully with no error. When I attempt to run it from "Localhost" as a web site, it just times-out on the merge document request with no message or error and does not launch the Merged document or
  • Problem with using VSTO in Infopath 2007
    by mantenar
    0 Replies
    Last post by mantenar
      • I installed VSTO 2005 SE. When I try to access it from Infopath, i get the error - The project can not be openned becasue the in-process host is not registred. Contact support for the host application. I have trial copy of Infopath 2007 ( office 2007). Do i need to have licesed copy to use VSTO 2005 SE. Please advise .thxs
  • 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;
  • Drag / drop file attachment from outlook
    by Becker2
    1 Replies
    Last post by Becker2
      • Using .NET 2.0 I'd assume there is some easy way to accept dropping a file attachment from an outlook email message onto a form I cannot seem to find any good example of this. I see some very convuluded vb 6 methods, surely there is some easy way to do this
  • Word from InfoPath
    by Jonesie
    5 Replies
    Last post by Cindy Meister
      • I'm trying to use VSTO to create a word document from an InfoPath form. I have the xsl's and xml from the submitted form. If I open the xml in word it knows that it can apply an xsl and if I pick one of them then I get a page that matches one of the InfoPath form views. Perfect! Well allmost. I need to create a document that contains ALL views and I need to automate this with VSTO wi
  • hard disabling add-in problem
    by davidMartin
    4 Replies
    Last post by Mike Walker
      • Hi, I developed an addin for Outlook 2003/2007 with VSTO 2005 SE. I distributed it to users but they sometimes encounter a problem. During outlook start, if the user stops Outlook and unfortunately Outlook was loading my add-in: At the next start, Outlook pops a message up to the user that Outlook experienced a serious problem with the ¡®myaddin¡¯ ¡­"Do you want to disable it " and by defa
  • Error opening Excel VSTO document as Outlook attachment
    by B Word
    2 Replies
    Last post by B Word
      • Hello, I've developed a .NET 2.0 VSTO assembly to extend an Excel 2003 spreadsheet. When the spreadsheet is sent as an attachment to an Outlook email message, the receipient cannot successfully open the spreadsheet directly. It works if the spreadsheet attachment is first saved to disk then opened. The error is "The customization does not have the required permissions to execute
  • API to retrieve Address from outlook address book?
    by Malleswar
    13 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi, Can any one guide me or provide the link to retrieve Address from outllok address book Thanks in Advance
  • Workbook.save() not behaving as expected.
    by Rishab
    3 Replies
    Last post by Geoff Darst - MSFT
      • I have a VSTO 2005 SE add-in for excel in which I need to programatically save the document on an event. When I tried workbook.save() to accomplish this the workbook gets saved with its temporary name eg "Book1.xlsx" in My Documents and doesnt pop-up a save as dialogue even with a document which is previously unsaved. I tried this with a word document and there the behaviour was as expec
  • AppCheck and Office 2007
    by Douglas H. Troy
    2 Replies
    Last post by Douglas H. Troy
      • Based off the VSTO deployment MSDN "guide", for my Office 2003 VSTO solutions, I have implemented AppCheck as a means to determine if Office 2003 and Word are installed. Now that Office 2007 has come out, I need the related Product and Component codes, so that I can properly update AppCheck to work with that release of Office. Can anyone provide some information/guidance on this Thank
  • Using VSTO to put Control on VBA form
    by Adrian Leeming
    2 Replies
    Last post by Adrian Leeming
      • I am trying to put a dotnet userControl created using vb.net on a Word VBA userform. The class has been marked with a comclass attribute and I have set up registry routines to add control, typelib and version and InProcServer32 keys. The control when added to a User form in word appears fine on the form and in Words object inspector. However it does not appear in the drop down for the con
  • Outlook-Add-In
    by T_B__86
    5 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi, I'm working on an add-in for Outlook 2007. In Outlook I have several mailboxes(Imap) How can I get the "Sent"-Folders of each mailboxes Code Snippet Application.ActiveExplorer().Session.GetDefaultFolder(OlDefaultFolders.olFolderSentMail) //So I only get the "Sent"-Folder of the first mailbox
  • VSTO deployment solution not working in IE
    by ClaudiaHelpOnVSTO
    11 Replies
    Last post by Electric Boogie
      • Hi, I have a VSTO 'code behind' solution which is deployed on a server. User who want to open such a Word document, download and access the document via a browser. Once the browser has downloaded the .doc file, the user clicks OK to open the document on his machine. When I try this solution with Mozilla Firefox everything works perfectly fine: the VSTO document is opened and my assembly starts ru
  • Ribbon not loaded
    by davidMartin
    7 Replies
    Last post by Ahmed Alaoui
      • Hi, In my addin ( Outlook 2007 and VSTO 2005 SE), I created different ribbon customizations that I load at runtime. I create the xml at the "GetCustomUI" call. When I debug in VS, everything works great but when I deploy it, my addin is working well expect my ribbon customizations... ( my addin is noted as "activate" in the complement menu ) I check the "Show add-in user i
  • Does MS ActiveSynch change the EntryID or other properties in Calendar (appointment) items or Tasks?
    by mdpowersslo
    0 Replies
    Last post by mdpowersslo
      • We have an Outlook Add-in built using VSTO2005 that synchs contacts, appointments, and tasks with Outlook from our C# application with a SQL Server 2005 backend. In order to find and re-synch with items, we save the Outlook item's EntryID in a table in our database. Occasionally, after synching to a PocketPC-based PDA, we cannot find the Outlook appointment or task item via the EntryID stored prev