Office

Page 147




  • Topics
    Replies
    Last post
  • Security problem Word 2007 add-in
    by EagleWizard
    6 Replies
    Last post by EagleWizard
      • In the add-in itself I use reflection. An other programmer can give me a DLL file with actions (functions) and with the class, namespace and the path of the DLL I can use these functions in my add-in. I tested everything in a windows application and it worked perfect. After that I tried to use the same code in my Word add-in but I got a Security error. Here is the code where I had the problem:
  • VSTO 2005 SE Installaion issues
    by NemanjaTheLost
    13 Replies
    Last post by Amol Gholap
      • hi, i'm having problems with the installation of the vsto. i run the vsto 2005 se installation package and the PIA install for office 2003 but when i try to run code samples i get the following error: Error: The operation could not be completed. No such interface supported this also happens when i try and build my soulution. am i doing something wrong or are there any known conflicts wit
  • using office2007 color control
    by Jescorza
    2 Replies
    Last post by Cindy Meister
      • Hi. I'm working on an Excel VBA project and I was wondering if there's any way I can use the color control that displays in every office07 application (the one you get when clicking on the painting pale, for example) into my Userform. Thanks for your support.
  • Controlling Design Mode
    by Harry Sauers
    4 Replies
    Last post by Harry Sauers
      • I¡¯m working on a managed code, Word 2007 Add-In using Visual Studio 2005 with VSTO and VSTO SE. From this Add-In¡¯s managed code, I would like determine whether or not the active document is in Design Mode . Does VSTO provide such a mechanism Also, is there some way to programmatically enter Design Mode on the fly Thanks, Harry Sauers
  • Mail Merge Visual Studio 2005 Office 2003
    by ducmis
    12 Replies
    Last post by HBN
      • Can someone direct me to the correct forum/thread/site to help me with Mail Merge with VSTO I can do a mail merge just fine with Word 2003, but I don't know where to start in VSTO. I want to be able to program in VS2005 and manipulate the data after each merge Private Sub ThisDocument_MailMergeAfterMerge( ByVal sender As Object , ByVal e As Microsoft.Office.Tools.Word.MailMergeAfterM
  • VSTO Outlook 2007 custom commandbar not appearing
    by E K R
    10 Replies
    Last post by E K R
      • Hi all, I have developed an add-in for Outlook 2007 using VSTO 2005SE on on Vista. I have an application that adds a new commandbar to Outlook's menu commandbar. On my development machine I am able to run my application in the debugger, and Outlook opens with the new commandbar and everything works just fine. After building the setup project, I then send the setup application and msi instal
  • Outlook 2007: trouble with PropertyAccessor.SetProperty
    by 280Z28
    6 Replies
    Last post by 280Z28
      • The following code is throwing a COMException (0x80020009) on the second line. The actual_date object is a valid DateTime object (and it does have the date I wanted) when watched after the first line. The property accessor is from a MailItem object. object actual_date = oPropAccessor.GetProperty( "urn:schemas:httpmail:date" ); oPropAccessor.SetProperty( "urn:schemas:httpmail:datereceived", actua
  • UDF support in Excel 2003 with VSTO .net
    by Denis Pitcher
    3 Replies
    Last post by Mohit Gupta - MSFT
      • I'm in the process of figuring out how to migrate an old VBA based Excel Add-in to VSTO .net Quite unfortunately, UDF function support in Excel is critical for the add-in I'm updating and yet it is not supported in the present version of VSTO nor will it ever be with Excel 2003. Thus, I'm stuck figuring out a means around the issue. After a great deal of digging, I found a means to create
  • Get The text of Words from a word document
    by Corby111
    14 Replies
    Last post by Pweeks
      • This may be a topic for some other group, but this group gets replies faster then then Automation or some other Word groups, so maybe someone here knows this. I really want to thank Cindy for pointing me in the right direction for what I wanted to do. I ended up using the DsoFramer control to host my word doc, and now I have the document loaded, when I first saw the Word.Document.Words collecti
  • Setup file problem(update manifest)
    by Malleswar
    4 Replies
    Last post by Lubo Birov - MSFT
      • Hi, I am developing the Installer by following this link http://msdn2.microsoft.com/en-us/library/bb332052.aspx Actually I am getting small problem. In updatemanifest.cs and in UpdateApplicationManifest() // Get the application manifest from the document. string documentPath = Path.Combine(targetDir, documentName); System.Windows.Forms.MessageBox.Show(documentPath); Server
  • Outlook add-in : LoaderLock and AccessViolation problems
    by Tadwick
    7 Replies
    Last post by Tadwick
      • Background: I am writing a .Net 2.0 VSTO SE add-in for Outlook 2003. The add-in provides the following functionality: 1. Toolbar and button created when the add-in loads 2. Button loads a modal windows form FormA 3. FormA launches a modeless FormB with a webbrowser control 4. The webbrowser navigates to a local HTML file that uses an embedded ActiveX control and javascript (I use CoInternetSetFe
  • C# COM server visible in Excel "Insert Object..."
    by DAS1108
    9 Replies
    Last post by DAS1108
      • Hi, I want to create an C# COM server which will be visible at "Insert Object" in Excel. I found many examples how to create an C# class and use it from VBA. But what I have to do that I can insert such a C# class within an Excel sheet directly without VBA Of course I need to implement some additional interfaces, but which ones and how in C#. Thanks. Daniel
  • How to I saved a email item and put it into a task item?
    by VSFW3
    2 Replies
    Last post by VSFW3
      • Hi, I want to ask is there a way for me to save a email item and put it into a task item. For example, there is a icon of a email item in the body of a task item, when I click on the email icon, I'm able to open the email. Thanks...
  • XSLT Newline within Excel Cell ignored
    by blg
    1 Replies
    Last post by Cindy Meister
      • I have an xslt file transforming an xml file to generate an Excel spreadsheet file. Everything works great except I am unable to insert a newline within an Excel cell. When I do it manually from within Excel using Alt-Enter, and save the file as xml, Excel has inserted " 
" . When I do the same in my xslt, Excel ignores it. Wraptext is on in the cell. I have tried wrapping it in
  • Bugs on feedback
    by brhoom
    5 Replies
    Last post by brhoom
      • This question is addressed to MSF people: I have posted some bugs related to VSTO on the feedback site of visual studio but till now no one acted on them. How long usualy it takes to respond to a bug Also if you may have a look at them and post any workarrounds or solutions. Posted bugs: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=237414 https://
  • 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
  • Create MergeField from string
    by Toxter
    7 Replies
    Last post by Toxter
      • Hello everyone. I'm developing Word 2007 AddIn in C#. What I'm trying to implement last couple of days is drag&drop from my custom task pane to Word document. I'm trying to drag&drop and when object is dropped to create MergeField. All I could do so far is to drag&drop string (text). So, the main question is: Can I format text which will be dropped to Word in
  • XML Tags in VSTO documents disappear
    by pnp
    7 Replies
    Last post by pnp
      • Hi all I have a somehow weird problem. We have implemented at Word VSTO Solution. In this word document we use a lot of XML tags to locate data and be able to extract it from the document, and save the document as XML and send this to a reporting tool. All this works as expected. The problem appears when a person from our company HQ sends the Word document to one of our subsidiaries.
  • Custom form gets priority against a VSTO formregion
    by Raul Rosenloecher
    2 Replies
    Last post by Raul Rosenloecher
      • Hi, I'm working on an Outlook-addin (C#, FormRegions, VSTO 2005 SE, Outlook 2007, special message class "IPM.Note.*"). But there has also to be some compatibility with a former version, which is realized by custom forms, which get downloaded automatically from the exchange server. So I have 2 forms - a custom form and a new FormRegion based addin and I wish the following behavior: If my
  • Action Pane Disappear
    by Peter Peter
    4 Replies
    Last post by FlashFan
      • Hi, I have load a action pane to a Excel workbook, in the mean time, I double click another normal Excel file and then switch back to my VSTO Excel file. I found that the Action Pane disappeared. How can I get it back (The action pane can't be appeared again even I press Ctrl+F1 in Excel 2003) Thanks,
  • Problem in data export
    by umeshawasthi
    1 Replies
    Last post by Cindy Meister
      • Hi All, I am exporting data from th table in the word to the excel but i am facing a problem while exporting it currently i am using excel , use the data >> Import External data >> New Web Query option. but i have some column with data like 7/5 etc when exporting this the excel is converting it to date format while the actual data is not a data data it is some thing other
  • Console Application to Create excel report and put a macro into it...(using C#)
    by senthildekumar
    1 Replies
    Last post by Mohit Gupta - MSFT
      • I managed to create an Excel report using a console application in C#. I wrote a macro that prints all pages on clicking a command button. The code that does this part is : Console.WriteLine("Adding button to the workbook for Printing.."); Shape btnPrint = sheet1.Shapes.AddOLEObject("Forms.CommandButton.1", _missing, _missing,_missing, _missing,_missing, _missing, 50, 200, 60,
  • send an email without confirmation
    by Ori'
    4 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hello, I'm trying to send an email trough outlook using its API. Something like: Outlook. _MailItem oMailItem = (Outlook. _MailItem )oApp.CreateItem(Outlook. OlItemType .olMailItem); oMailItem.To = toValue; oMailItem.Subject = subjectValue; oMailItem.Body = bodyValue; oMailItem.Send(); The problem is that the send method raises a confimation dialog, that I want to avoid.
  • Cannot Install/Use Remote Debugger with VS Tools for Office 2005
    by TonyHigh
    13 Replies
    Last post by TonyHigh
      • I cannot seem to debug projects in VSTO 2005, C# or VB. I get the message "Error while trying to run project: Unable to start debugging. The components for the 64-bit debugger are not registered..." I think I tried almost everything I reinstalled, uninstalled, and reinstalled w/ as few services running as possible and I emptied the temp dir. But even with this it refuses to install th
  • 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.