Office

Page 175




  • Topics
    Replies
    Last post
  • ConfigurationManager
    by Lily Collins
    2 Replies
    Last post by Lily Collins
      • I am using Visual Studio 2005 Professional edition with VSTO SE. I have .NET Framework 2.0 (and 1.1) installed. I am trying to write a method that captures a value from the app settings section in an app.config file (I am writing an Outlook 2007 add-in) , I have a using directive as follows: using System.Configuration; When I try to use the ConfigurationManager class it i
  • VSTO adn ASP.NET
    by Priyananth
    2 Replies
    Last post by John R. Durant - MSFT
      • Hi, I need to do a Word Mail Merge upon a button click. This is working fine when its being done in Visual Studion IDE. When it comes to deployment, It was saying Com Access Authorization error ... I solved that in DCOM configuration and gave the necessary permission to the ASPNET user. But now i get a error message "There is insufficient memory. Save the document now". t
  • How does the WordOpenXML keep track of spaces between the text..?
    by Anita H Punjabi
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I have a Word 2007 document. It contains 2 words with many spaces between them. e.g: sample document. Now the WordOpen XML generated for the same is as below: < w: p w:rsidR =" 0077400B " w:rsidRDefault =" 00B9393A " > < w:r > < w:t > sample document
  • Change Outlook email address "to" in BeforeCheckNames()
    by Alexander Olekhnovich
    3 Replies
    Last post by Christin-MSFT
      • Hi all, I'm developing an MS Outlook Add-in with VSTO (VB.NET). I've to change an email address before sending it, but here is a problem that the field "to" is ReadOnly. So I've to turn off the email address verification or change that field in BeforeCheckNames() somehow. Any ideas Best Regards Alexander Olekhnovich
  • JournalItems: Adding Contacts and Companies
    by Apuhjee
    4 Replies
    Last post by Apuhjee
      • Could someone please post some example code for creating a new JournalItem associated with a Contact   Attempting to set either the ContactNames or Companies properties is seeming to have no effect. We have a large Access database of customers with an associated phone log that we're trying to get into Outlook.  Without the ability to programmatically link Contacts and JournalItems, we
  • Outlook 2007
    by boltnia
    11 Replies
    Last post by boltnia
      • Hi to all! I'm interested in some question about Outlook 2007. The fact is outlook can receive and send messages in .eml-format. So, application can works with it. But if I try to open manually local file *.eml - error is generated. Can I write code to open file in .eml format Thanks.
  • Office 2003/2007 separated
    by bmains
    2 Replies
    Last post by bmains
      • Hello, This article http://msdn2.microsoft.com/en-us/library/0es5szt7(VS.80).aspx claims that there are separate 2003/2007 templates, but in my Visual Studio 2005, I only have one, even though I have Office 2007 installed. Is there something I'm missing I still have 2003 installed as well. Thanks, Brian
  • Form opening up a word.dot VSTO
    by ducmis
    4 Replies
    Last post by ducmis
      • So I have a word.dot called VSTO-POC01.dot that has some code at startup event where it opens up a total of three exact same templates.  Now I have added a simple Window form--inside the same solution-- to open VSTO-POC01.dot when the user clicks on a button. It opens the .dot file, however it only open one .dot and stops. The other two were never processed.  Here is my code. The code
  • Force Outlook to Reload Form Region Manifests
    by Jared Brogni
    2 Replies
    Last post by Andrew Cherry [MSFT]
      • I'm working on an Outlook AddIn that dynamically adds form regions depending on options selected by the user. When a user adds a new business process view, I add the correct form keys for the form regions for that new business process view. The problem I've run into is that Outlook only reads those registry settings and then loads the manifests for the registered form regions on startup. So, my ne
  • Resolution
    by Greg M
    11 Replies
    Last post by Cindy Meister
      • Hope I'm nearing the end of questions here, and thanks again for reading. I have a Excel2003 Applcation Level Add-In made using VSTO with SE download. Deployment package is made, I can see that registry entries are being made, that CAS policy has full trust and that prereqs are loaded. I have set the suppressdisplayalerts environ variable =0 to see why the add-in is not loadin
  • VSTO 2005 SE Problems...!!!
    by Galoleins
    4 Replies
    Last post by Galoleins
      • Hi everyone! I installed recently the VSTO 2005 SE in my computer. Also I have installed VS2005 Professional. My question is: Why I don¡¯t have the office projects' 'Word Document', 'Excel Document' an so on installed on the Visual Studio 2005 Instead, I have only the adds-in of this ones. Can Anyone tell me wich installer(s) I have to download in order to get this kind of projects (I mean 'W
  • Embedded Tables
    by Ockert Labuschagne
    2 Replies
    Last post by Ockert Labuschagne
      • I need to programmatically build tables that have multiple levels of embedded tables. I'm using: Table table = document.ActiveWindow.Selection.Range.Tables.Add(document.ActiveWindow.Selection.Range, 1, 1, ref defaultTableBehavior, ref autoFitBehavior); Cell cell= table.Cell(1,1); Table table2 = cell.Tables.Add(cell.Range, 2, 1, ref defaultTableBehavior, ref autoFitBehavior); Cel
  • How can I use "Solver Add-in" of Excel in a macro in MS Access?
    by Nima Amin
    3 Replies
    Last post by Helmut Obertanner
      • I have a macro in Ms Access which I want to use the "Solver Add-in" of Excel in it. But there is a problem in it. At the first I open the Excel application and set it to "objExcel". Then I install the new Add-In by this command: objExcel.AddIns("Solver Add-in").Installed = True The Add-In installs successfully but I don't know how to use it. The sample usage of Solver Add-In in Excel
  • Activate an already open Excel workbook
    by Roman Benko
    6 Replies
    Last post by Cindy Meister
      • Hi I am using VB .net 2005 and Office 2007. When I execute the following line Dim workbook As Excel.Workbook = excel.Workbooks.Open( "c:\temp\test.xlsx" ) I get a message from Excel saying that the workbook is already open and if I want to open a read-only version of it. I would like to be able to open it if it is closed and activate it if it is already open. Is there way to
  • xlDialogSaveAs does not work
    by Jens Sauer
    4 Replies
    Last post by Jens Sauer
      • Hello, I tried to use the xlDialogSaveAs dialog in the BeforeSave event. My problem is, that the dialog does not appear. Here is the code: private void BeforeSaveExcelWorkbook(Excel. Workbook workbook, bool SaveAsUI, ref bool Cancel) { Excel. Dialog fileSaveDlg; fileSaveDlg = this .Application. Dialogs[Excel. XlBuiltInDialog .xlDialogSaveAs]; fileSaveDlg.Show(mis
  • How to display custom tags value in Powerpoint 2003 in VSTO 2005 SE?
    by DKUS007
    3 Replies
    Last post by Cindy Meister
      • Dear All, I am using VSTO 2005 SE to add custom tags in PowerPoint 2003. Also displaying the value as messagebox on a click of a button in custom menu bar. But my client want to display it on the right pane i.e, when someone click on any slide respective slide's custom tags should display on the right hand side window/pane I know this is possible in PowerPoint 2007 using custompane but my c
  • F5 -> "File already exists"
    by Victor Hadianto
    14 Replies
    Last post by Mike Walker
      • Hi, I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then. Strange tha
  • Crash in VSTOApplicationManifestEditor using VSTO 2005 SE (HRESULT 0x8004040A)
    by Shaun Logan
    2 Replies
    Last post by Scoober
      • I am seeing an exception using the sample App Manifest Editor ( here ). My steps are: download and build the sample App Manifest Editor (my dev machine has VSTO 2005 , ie. Microsoft.VisualStudio.Tools.Applications.Runtime ver: 8.0.50727. 42) create a new, empty XLS file (using Office 2003 Professional w/SP2 - Excel 2003 ver 11.8105.8107 - SP2). There is no VSTO customization attached at
  • Can't sink the inspectors event in the Outlook2007
    by Peter.Zhao
    1 Replies
    Last post by Mohit Gupta - MSFT
      • I created a Com-Addin base on the outlook, below code works well in the outlook2003, but in the outlook2007, it will throw an exception from the first line. And this piece of code is called in the onconnection() method inherit from the interface IDTExtensibility2.  HRESULT hr = m_inspectors->QueryInterface(__uuidof(IConnectionPointContainerPtr), (void**)&pCPCtr); pCPCtr->FindConn
  • Customizing the context menu in Word 2007
    by Gastiflex
    7 Replies
    Last post by Cindy Meister
      • Hi, I'm working on an add-in for Word 2007 and I'm trying to add some entries in the context menu. I've added this code in the function ThisAddIn_Startup : Code Snippet Dim app As Word.Application Dim btn As Office.CommandBarButton app = Globals.ThisAddIn.Application btn = app.CommandBars("Text").Controls.Add(Office.MsoControlType.msoControlButton) btn.Caption = "Hell
  • Problem: insert formula in a Excel cell
    by ROLLYTONIN
    0 Replies
    Last post by ROLLYTONIN
      • I'm developing an add-in for Excel 2003 in c# with VS2005 that export team project cost from a business database. I must insert a formula in a cell because the project manager must perform analisys type "what if". Our Project Manager use english and italian version of Excel so I want write code that work correctly in both versions. I wrote in c# this function: protected virtual void I
  • Regarding excel class name
    by Asim Patnaik
    4 Replies
    Last post by Asim Patnaik
      • Hi, When I enumerate through an excel window for all the child windows, I get various class names. One such class name is Excel7 which I guess if for a workbook. Is this class name same for all versions of Excel I am using The reason is that when I ran the code for Excel 2000 and 2003, I got the same class name for the workbook. Please help me understand this. Regards, Asim.
  • Gallery items with descriptions below
    by Kostadin Georgiev
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hello I have added a gallery control that is dynamically loaded with items in my Ribbon XML. I need to show the items captions in bold text and some descriptions below each item caption (on a new line). My gallery must look like the Size gallery in Word's Page Layout tab, Page Setup group. How can I achieve this Thanks, Kostadin
  • Problem deploying Shared COM-AddIn application
    by HemKumar
    2 Replies
    Last post by Dennis Wallentin
      • I've been developing excel add-in using microsoft interop and with the shared- addin template but i face the following problem When I go to build ProjectName Setup, it packages the dependencies into a Windows Installer package. I then send the contents generated in Release\ ProjectName Setup to one of my colleagues to beta test. He runs the installer and it says the install was successful. Howe
  • missing prerequisites when preparing setup project
    by haibin_sh
    3 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I have an application-level add-in project. I'm preparing a setup project for the add-in. When I right-click the project properties and click prerequisites, I cannot find the two prerequisites: Microsoft Visual Studio 2005 Tools for Office SE Runtime Microsoft Office 2003 Primary Interop Assemblies My add-in is running fine. Any idea why the two prerequisites are missin