Office

Page 104




  • Topics
    Replies
    Last post
  • Index was outside of bounds of the array error in VSTO Excel application
    by Dmitry Kholodkov
    1 Replies
    Last post by Cindy Meister
      • We are encountering an error in an application when we are trying to import XML data Te application is an Excel smart document. The error is being reproduced all the time. The sheet data is being populated but with an exception that returns "Index was outside of bounds of the array" error Microsoft.Office.Interop.Excel. XlXmlImportResult xl = new Microsoft.Office.Interop.Excel.
  • VSTO SE ClickOnce + User prompt
    by Kulvinder
    2 Replies
    Last post by Denis Pitcher
      • Hi, I have created a simple "Hello World" VSTO 2005 SE Outlook 2003 Addin. I have published it on my network and it is working fine. I want to know that if i need to have an automatic update through ClickOnce, is it possible that i can have a User prompt in case the dlls deployed on UserMachine are of an older version. Right now, my program is doing this silently but i want that t
  • How can I find out if Word is loaded in Outlook?
    by vitich
    4 Replies
    Last post by Sue Mosher - Outlook MVP
      • I'm creating Word Addin with VSTO 2005 SE. I need to disable some functionality in case Word loaded in Outlook (when I compose email for example). How can I find out if Word is loaded in Outlook   Thanks, Victor
  • Intermittent HRESULT: 0x800A03EC setting value in a cell
    by rfl
    1 Replies
    Last post by Andrew Whitechapel - MSFT
      • Hi, I get this error intermittently (here's the error, stack trace and code): Exception from HRESULT: 0x800A03EC Server stack trace: Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Office.Interop.Excel._Work
  • Fixing Bad Office.Core Refernce in xl2003 Application Add-In
    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
  • Cached Data from Website to Word Doc
    by gbobg
    1 Replies
    Last post by gbobg
      • Hello, I am having an issue with cached data in a Word document that is getting setup by a web page, but it only has an issue on the web server. I have a word document report that is being triggered to open from a web page and it is auto populating based on cached data and a web service. The code is very similar to the Benefits Registration Sample:http://msdn.microsoft.com/library/default.asp url
  • Excel Debugging
    by A7Zulu
    2 Replies
    Last post by Ji Zhou ¨C MSFT
      • I am trying to create a DLL that Excel will use, how do I debug my functions from Visual Studio I believe I have set my properties correctly, but nothing loads. Thanks, Aaron
  • Minimum Office 2007 version required for VSTO
    by Babba72
    2 Replies
    Last post by Babba72
      • Hi, i have to understand wich minimun version of Office 2007 can run VSTO solutions (not VSTO 2.0, old solution VSTO) made with framework 1.1 I have searched on Office web site but i'm not able to get this information (there are several versions of Office...) In Office 2003 it was required PRO version (the standard and small businnes version not have programability .NET) Thanks in advance
  • VSTO Excel Referance question
    by lrjanzen
    1 Replies
    Last post by Ji Zhou ¨C MSFT
      • I am consolidating the saves for a number of worksheets in the ThisWorkbook.vb. I hve a menu that calls a save event handler. Each worksheet has several data bindings and lists that need to be handled uniquely on each worksheet. for instance on Sheet1.vb I have Me .BeBindingSource.EndEdit() or a sub Private Sub SaveApprovalValues() CODE HERE End Sub on Sheet2 Ho
  • Conversion of Attachments embedded in an mail
    by Alhambra Eidos Kiquenet
    3 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi misters, I want to access attachments of a mail (MailItem) and if attach type is olEmbeddedItem , convert it to olMailItem in memory. Now, I have this code, saving attachment (.msg file) to disk and using CreateItemFromTemplate. Another solutions without save to disk the msg file Any help will be very grateful, thanks in advance, greetings, regards The code here:
  • Dynamic creation of CommanBarButton Issue
    by Ilya Cherkasov
    2 Replies
    Last post by Ilya Cherkasov
      • Hi everyone! I try to make some logic with adding and deleting CommandBars within Word AddIn Project, so that my life gets easier when application business will make it's move. I have ToolBarController component that can have CommandBars (or CommandButtons) created, deleted, locked, and so on. Here's a little of it's logic (yes it contains issue ) private void AddButton(
  • Printing Word docs closes my VSTO template
    by John Simons
    6 Replies
    Last post by John Simons
      • I'm using Microsoft Visual Studio Tools for Office, and I have the following problem: If I create a new Word Template project (Visual C# | Office | Word Template) and then press F5 to start it up, it all works and MSWord2003 starts up as expected. But then if I right click on any existing Word doc file (no VSTO) and select Print from the context menu, my VSTO Template closes unexpectedly. I wonder
  • How to get the icon for a given item?
    by Dmitri Pozniak
    2 Replies
    Last post by Dmitri Pozniak
      • Hello everyone, I am trying to get an icon for a random item -- e.g. MailItem or TaskItem -- that is displayed, for example, in a ToDo list, Reminders window, etc. The only thing I managed to do is: Code Snippet mailItem.PropertyAccessor.GetProperty("http://schemas.microsoft.com/mapi/proptag/0x10900003") and it returns a mysterious value of 2 Does anyone have any ideas on h
  • Problem with custom Excel menu for copying sheet to new workbook...
    by Sebastiaan Brozius
    5 Replies
    Last post by Sebastiaan Brozius
      • Hi y'all, I have a problem with an Excel AddIn. It's made with CS2005 and VSTO2005SE for Office 2003. I have made a menu entry for copying the contents of the currently active sheet to a new workbook based on a template with a set header and footer, print that workbook and then close it without saving. Works (finally!), but after doing this for, say, one or two times, all menu ent
  • Outlook 2007 add-in o2007pia.msi install error
    by E K R
    4 Replies
    Last post by Carlos Oropeza
      • Hi, I have developed an Add-in for Outlook 2007 and deployed it successfully on a couple different machines But with others I am getting an error when setup.exe is trying to install o2007pia.msi file. So then I try running o2007pia.msi on its own and I receive the error "Error 1316. Setup cannot read from file C:\Eric\PIAREDIST.msi. Check your connection to the network, or CD-ROM
  • COM Exception in CommandBars["Task Pane"].Visible = true
    by mobigital
    6 Replies
    Last post by John R. Durant - MSFT
      • I am getting this occasional COM error when trying to ensure that Document Task pane is visible: This code: Globals.ThisWorkbook.Application.CommandBars["Task Pane"].Visible = true; Causes this exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at Microsoft.Office.Core.CommandBar.set_Visibl
  • 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;
  • Is there any "Hello World" tutorial for an Outlook 2007 Add-in ?
    by TomJ72
    4 Replies
    Last post by TomJ72
      • When I tried to create an add-in for Outlook 2007, I thought everything went smooth and seemed okay, even compiling the project and starting outlook when I clicked the play button. However, nothing happened, i.e. the code in the method "ThisAddIn_Startup" does not seem to ever become executed, but I never get any kind of error message.... Here is what I have tried to do from Visual Studio 2005 Pro
  • Need to add a folder-group at the root of the Outlook 2003 treeview..
    by Hir&#2
    4 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi, I am working on an application which is has a Document Store and is supposed to be tightly integrated with MS Outlook 2003 ( which is s upposed to act as one of its client ). Now, using VSTO, I am able to add the folder(s) under the current root folder i.e. - Mailbox <user name> |--- Drafts |--- Inbox |--- <My Document Store Folder-Group>
  • Extending Word 2007 Content Controls/Implementing the ContentControl Interface for our own Controls
    by Toby Russell
    1 Replies
    Last post by Cindy Meister
      • Hi, Is it possible to extend Word 2007 Content Controls in any way I notice there is a Content Control interface; could one develop custom Content Controls by implementing this interface I would also like to be able to modify the right-click menu, when over Content Controls in particular for Word, but also for Office 2007 in general Thanks, Toby
  • Getting default Mso labels
    by Jan Ku&amp;#269;era
    3 Replies
    Last post by miloush
      • Hi, I'm sure that during developing with VSTO 2005 SE I saw somewhere functions like "getMsoLabel" and "getMsoImage"...but I can't find them anywhere now... anybody knows about them I need to get string of built-in control / group / tab... in order to handle localized versions of office... and I hope a little this functionc could do that work.. Thanks
  • 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
  • How to increase the size of an image in toll bar of excel.
    by Bharanee
    3 Replies
    Last post by Cindy Meister
      • Hi, I'm using an image in excel tool bar. The image actual size is 135 x 90. But when it displayed in toolbar its 16 x 16. Let me know how to increase the displayed image size in the tool bar. It will be very helpful for me to proceed further, if the solution reaches me in short.
  • Getting Word compatibility/version info for active document
    by wordyone
    3 Replies
    Last post by sdangelo
      • I am working on a VSTO SE addin for Word 2007 (written in VB.Net). On the DocumentOpen event, I need to get information on what version of Word the document was created in. This worked in prior versions of Word but seems to fail with Word 2007 object model: App.Dialogs(Word.wdWordDialog.wdDialogToolsOptionsCompatibility).Product The Product property is in the object model docu
  • Problem looping through mailItems in Explorer selection collection in Outlook 2003
    by planza
    0 Replies
    Last post by planza
      • I am iterating through mail items in explorer.selection. If I select only 1 message, I can save it to a msg file with no problems. However, I get an invalid cast exception after the first item in my selection when I try to run my routine on multiple mail items. I have posted my source code below. I am vb.net 2005. Any help will be appreciated. Thanks. '-----------------------------------------