Word VSTO Issue.

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - Office
  - VC++
  - Dotnet
  - Windows Live
  - ISV
  - Windows Forms
  - Game
  - SQL Server
  - VB
  - Architecture
  - IE
  - VFP
  - Visual C#
  - Windows Vista
  - SharePoint
  - Smart Device
  - VS 2008
  - VS Express
  - Visual Studio

- Previous
  - 1
    - UDF FOR EXCEL 2003 USING VSTO 2005 SE. hi guys i am pretty new to vsto 2005 SE. i have created a add-in using VSTO 2005 SE. i want to write a user defined function say Add(int,int). when we write in the cell =Add(1,2) this will return us the sum. i want to ask where this Add function will be declared and what other refrences are required. i want to know how UDF are used and declared . please enlighten with the above example if possible. otherwise give idea in steps. plzz help me. Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 2
    - Word 2007 Interop problem Hi, I've upgraded to Office 2007 from Office 2003 and am having some trouble getting some software I made that uses the Word Interop to do search and replace working. I changed the reference to the new Interop assembly I got from the Primary Interop Assemblies . I tried converting my template documents to Office 2007 format, but that didn't seem to help. Everything else seems to be OK but I get an error at sel.Find.Text... Dim sel As Selection = app.Selection For Each objRep As ReplaceWord In DirectCast(arrReplaceWords.ToArray(GetType(ReplaceWord)), ReplaceWord()) sel.Find.ClearFormatting() sel.Find.Text = objRep.OldValue sel.Find.Replacement.ClearFormatting() The error I get is... System.Runtime.InteropServices.SEHException: External component has thrown an exception. at Microsoft.Office.Interop.Word.Find.set_Text(String prop) at ContractCreator.ContractGen.btnPrint_Click(Object sender, EventArgs e) Any one have any ideas on how to fix it Thanks in advance... Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 3
    - How to: Call native PowerPoint functionalities from my own commandbar? I had created a custom commandbar, and I would like to create some commandbar buttons which have the same functionalities as the buttons in PowerPoint toolbar, such as 'Format Painter' in 'Standard' toolbar. Thanks in advance Kenneth Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 4
    - Ribbon menu and Toggle buttons Hello. I created group with 3 toggle buttons: < group id ="SData" label ="S Data" > < toggleButton id ="SDataAssignmnets" size ="large" label ="Assignments" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="Folders 32 n p.png" /> < toggleButton id ="SDataCustomers" size ="large" label ="Customers" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="File and Folder 2 32 n p.png" /> < toggleButton id ="SDataContacts" size ="large" label ="Contacts" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="Contact 32 h p.png" /> </ group > I want to use they like radiobuttons (only one button can be pressed simultaneously). How can I do that Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 5
    - Installed Office version. Hi, Right now, I'm using the key below to detect the version of office installed. HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Application\CurVer My problem is, if the target computer have both office 2007 and office 2003 installed, how do I detect how many version of office were installed My solution is based on VSTO2005 SE and VS 2005 Pro on XP SP2. Any help is appreciated. Regards, Westman Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 6
    - Outbox Frustration Ah I may have seen the problem now, it is worth working with the object as the correct type you validate to see if the object is MeetingItem type I would suggest you work on the object as this type just in case there is Resolve function is firing an error and VB Runtime Compiler is ignoring this - VB gets away with a lot of things if late bound. Regards Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 7
    - Best practices for VSTO SE Addins Hi Kulvinder, Yes, the codes I posted above only works on Outlook 2007. The Outlook.Folder object is also only available in Outlook 2007. I have tested on Outlook2003 just now, and it is very complicated about the Outlook's starup behavior, you can refer whitechapel's blog to get detailed information. I also find a trick which maybe solve your issue more or less: you can startup an instance of Outlook in FormLoad method or ButtonClick method,all denpends on you. And then get the handle to the instance to do automation. I have write some codes for your information: Code Snippet Outlook.Application myApp = null; private void Form1_Load(object sender, EventArgs e) { System.Diagnostics.Process.Start(@"C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE"); } private void button1_Click(object sender, EventArgs e) { myApp = (Outlook.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Outlook.Application.11"); MessageBox.Show("Connected!"); } private void button2_Click(object sender, EventArgs e) { Outlook.MAPIFolder inbox = myApp.Session.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderInbox); Outlook.Items myItems = inbox.Items; Outlook.MailItem mailItem = myItems.Add(Outlook.OlItemType.olMailItem) as Outlook.MailItem; mailItem.Subject = "Test"; mailItem.Save(); mailItem.Move(inbox); } In my codes, there are two buttons on a form. In the Form_Load event handle method, I run an new instance of Outlook with the statement System.Diagnostics.Process.Start(), then I should click button1, so we will get the myApp pointed the instance we created before(by using System.Runtime.InteropServices.Marshal.GetActiveObject() , so I can do automation in the button2_Click method(In my example, I Add a new mail into Inbox). Thanks Ji Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 8
    - Please advise on Add-in Express Hi, I know that this is a VSTO forum, but I need some advices: someone is willing to pay me a version of this program, since I cannot guarantee with VSTO to build a plugin for ALL Outlook versions (while this environment seems able to). I need to know any difference from working with VSTO, anything I should know: with VS and VSTO I had to learn about many (bad/sad) aspects, like deployment hell, problem with different Outlook versions and Outlook security model... Any idea about it Thanks LastHope Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 9
    - VSTO - Outlook AddIn and ContactItem Hello Jan, for me sounds like a typical Marshal.ReleaseComObject error. This means: you pass an Inspector object by ref to another method or class, or even start a second backgroundthread. Then in this method or thread call the ReleaseComObject method. Then your Outlook Inspector COM object is released and gone. Have a look for COM Objects passed by ref and the Released. If you pass it by ref - don't release or set to null If you don't pass it by ref set it to null (no ReleaseCOMObject) and do the GC stuff. Greets, Helmut Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 10
    - VSTO se sorting problem http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx I am trying this to convert John Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 11
    - Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007 Yeah I have side by side because it was the only way to continue to develop and test. But I have also another pc with only Office 2007 on it and I get the same exact error. Btw, my project is on CodePlex: http://www.codeplex.com/thbauthoring , if you might have time to look at it, you might find the issue. Regards, Laurent Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 12
    - Cypress Outlook 2007 addin installation problems Hi, I am facing a similar situation, guess its encountered pretty frequently. However, I have checked that the registry key, as mentioned by Martin does exist. Also, the MSDN article no longer exists. Does anyone have a concrete solution for this issue Any help would be appreciated.. Regards, Hiren Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 13
    - VBA: Outlook 2007 - enumerating attachments I am using VBA within Outlook 2007. I could not find an appropriate forum for this question. What I want to do seems basic (pseudocode): For Each OutlookMailItem having Attachment If Attachment is a picture (.gif, .jpg,.bmp) SaveToDisk (Attachment) End If Next Real simply: Each message must have an attachment. If the attachment is a picture, save it to disk. What is the best approach for this I cant seem to find a way because i'm stuck trying to understand GetTable which seems only to expose string representation of email properties. Is there some way to cast one of these properties to get the actual outlook email item Or what is the best approach to do as I need Thanks for any help. E Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 14
    - COM exception when trying to add picture as inline shape in Word 2007 RTM Hi Babu Even with the change you suggest I can't reproduce the problem :-( You mention you're using the ISmartDocument interface. Perhaps the problem is related to that. Would any events be firing in that interface They'd run asynchronously with graphics in Word, I'm guessing... Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 15
    - Word add-in and winform control Thank you I'll try to post on theses newsgroups Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 16
    - Is VSTO SE for Outlook 2007 in beta ? Hi, I want to know whether VSTO SE for Outlook 2007 is in beta Thanks Kulvinder Singh Tag: Visual Studio Tools for Office Word VSTO Issue. Office
- Next
  - 1
    - Previously working code breaks when VSTO2005 is installed? Hello, I have previously developed some applications using the ActiveX OUtlook View Control. These applications were working fine. I then installed the VSTO 2005 developers kit. Now, when I first re-opened the solutions that had my working code, I recveived a warning about newer versions of the assemblies that I was using, so I clicked on the warning and VS apparently re-referenced the newer versions. I then try to compile, but I received an error about a missing reference to the Microsoft.VisualStudio.Tools.Applications.Runtime assembly, so I add that to my list of references. The application now compiles again with no problems. However, when I run the application, I get a null reference exception when trying to access the Outlook.Application. Here are the pertinent to lines of code: this.outlookApp = new Microsoft.Office.Tools.Outlook.Application(); this.outlookNS = this.outlookApp.GetNamespace("MAPI"); The second line is the line that reeives the null reference exception. However, in the debugger, the this.outlookApp object is not null. Does anyone have any ideas why this just broke And, just for reference, I am using Outlook 2003. Thanks! Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 2
    - Word ribbon customisation not working Hi I tried customising the ribbon to show/hide a custom task pane (VSTO 2005 SE with Word 2007), as described in the walk-through - didn't seem to work, no custom "VSTO" tab was displayed when I ran it. I took the embedded resource route. Any hints on tracking down the problem Many thanks Paul. Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 3
    - Remove borders from Excel charts using C# Hi Becklighter I think the problem comes from applying a ColorIndex to the border after setting the line style to be "none". It seems doing that makes Excel think there is a border, even if it has no line. Remove that statement and things may behave differently Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 4
    - Send email using Outlook (Question 2) Even I'm getting this same error. --------------------------------------------------------------- System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005. --------------------------------------------------------------- I'm using .Net 2.0 to send Outlook Reminders. I've deployed this in server and it was working for the first couple of weeks.. I have Outlook also installed in the server. Can any one please help. Thanks in advance.. Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 5
    - Question re the CRM Integration Add-In Sample For Outlook 2003 (2) Wee, If this is an addin for Outlook 2007 ONLY, you may be able to do some integration using the custom task pane to display your items. This would give you COMPLETE control over how you display your data/items, and it would also mean you wouldn't have to have 'Outlook backed items'. Unfortunately, in OL2003, there are only two options for displaying data in explorer view... neither of them great IMHO :) The first being having outlook backed items and displaying the data using Outlook views, and the other being a complicated way of messaging betweeen hosting an ActiveX control in a web view hosted in the explorer window. I don't know the details about the second as I opted to NOT go that route! Cheers, ~Joe Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 6
    - VSTO - Excel 2007 Sheet Template Hopefully this is a simple issue and I've just missed it... In VSTO with Office 2003 I had an Office project option with an Excel Sheet template - not Add Ins. On my new development machine, I only have Office 2007 and Visual Studio 2005 Pro Edition installed. When I load the VSTO - SE, the only project options are for creating an Add In's for Excel, Word, etc. If I look at the Office project I only see a template for InfoPath. How can I create a project where I am designing the sheet like I did in Office 2003 Thanks, Tom Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 7
    - Outlook: MAPI fields versus User Properties For one thing, using CDO 1.21 in .NET code is not supported and can cause all sorts of problems. For another you should be releasing the object Imsg by possibly calling Marshal.ReleaseCOMObject on it after setting it to Nothing and then possibly calling GC.Collect(). Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 8
    - Using the Microsoft Office Document Imaging 2003 Viewer Control Do we need to have office 2003 installed to be able to use the above. I have the MDIVWCTL.DLL but can not seem to add it / use it within the IDE http://msdn2.microsoft.com/en-us/library/aa167614(office.11).aspx http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1758099&SiteID=1 Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 9
    - Installing Visual Studio Tools for Office 2005 VSTO 2005 has the requirement to have one of the following SKU (editions) installed: Microsoft Office Professional Edition 2003. Microsoft Office Professional Enterprise Edition 2003. Microsoft Office Excel 2003. Microsoft Office Word 2003. Microsoft Office Outlook 2003.* Microsoft Office Professional Edition 2003 Trial. Microsoft Office System Evaluation 2003 Enterprise Edition. The 2003 for students and teachers is not in the supported list, therefore the installer prompts you that Office 2003 is not installed (at least, the edition that is required). -= Maarten =- Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 10
    - Adding a custom Button in OutLook ? Hi , Is it possible to add a button on OutLook 2003 and add a functionality to it to save outlook msgs to desired extension in C# Can you please guide me to API in C# to how to do this Thanks, ZINk Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 11
    - Outlook PST file archive db I am in the process of developing an archive database for outlook PST, OST,etc... files. The design of the application will require the abillity to read these outlook files in and then convert them to a format that I can store in a database. The only problem I'm having is being able to open the outlook files into my application in a readable format. So far all I am getting is jibberish. Does anyone know how I can import these files into my application in a human-readable format Thank you! Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 12
    - Use Outlook 2003 to send meeting request using c# It looks like you're using System.Web.Mail from .NET 1.0, in which case the SMTP server is the address of the mail server that the user can send through, e.g. "smtp.mydomain.com." See http://www.systemwebmail.com/ This discussion has strayed pretty far afield from VSTO, so if you want to pursue it further, you ought to take it up in a general C# programming forum. Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 13
    - Access controls in different document instance (VSTO 2005) Hi, I have two different documents (A and B) and both have the same VSTO customization attached to them. [Actually I first create A and later open B and attach through the ServerDocument classe the VSTO solution]. How can I access a control instance (RichTextBox) of document A from B I got as far as this: // from document B, I try to find A // iterate over the open documents foreach (Word. Document parentDoc in Application.Documents) { if (parentDoc.Name.Equals(��A��)){ // iterate of controls in document A System.Collections. IEnumerator en = this .Controls.GetEnumerator(); while (en.MoveNext()) { MessageBox .Show( String .Format( "Field: {0}" , en.Current.ToString())); } } } Thanks for any hint! Claudia Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 14
    - Appointment time changes not propagating to OWA when appointment created with VSTO form ?!?!?! I have an application with a custom appointment form. Everything seemed to be working fine until my client noticed that when sync'ing their Pocket PC, their appointment times weren't always changing on the PDA. After two days of investigating, I have discovered that if I create an appointment with my custom form, and then try and change the times of the appointment, while still in the same Outlook session, then the time change does not propagate to OWA (Outlook Web Access), or to PDAs (which essentially also use OWA). Any other changes to the Body, Subject, etc. all propagate fine; just the times don't. So I have created a new (much simplified) AddIn to reproduce the problem. I have VS2005 with SP1 and with VSTO SE, running on a virtual Windows XP machine with Outlook 2003 SP3. To reproduce my problem, first reproduce my add-in: 1) Create a new VB Add-In for Outlook 2003. 2) Add a new Form called Form1, and add 4 controls: a) StartTime (a DateTimePicker, use a custom format that includes date and time) b) EndTime (ditto) c) Subject (a TextBox) d) Body (a TextBox; I made mine MultiLine) 3) Replace the Add-In code with the following: Code Block Public Class ThisAddIn Private WithEvents inspectors As Outlook.Inspectors Private Sub ThisAddIn_Startup( _ ByVal sender As Object, _ ByVal e As System.EventArgs _ ) Handles Me.Startup inspectors = Application.Inspectors End Sub Private Sub NewInspector( _ ByVal Inspector As Microsoft.Office.Interop.Outlook.Inspector _ ) Handles inspectors.NewInspector Dim appointment As Outlook.AppointmentItem = _ TryCast(Inspector.CurrentItem, Outlook.AppointmentItem) If appointment IsNot Nothing Then Dim aw As New AppointmentWrapper(appointment) aw.Show() End If End Sub End Class Public Class AppointmentWrapper Private WithEvents _appointment As Outlook.AppointmentItem Private WithEvents myAppt As Form1 Public Sub New(ByVal appointment As Outlook.AppointmentItem) _appointment = appointment myAppt = New Form1() myAppt.Subject.Text = _appointment.Subject myAppt.Body.Text = _appointment.Body myAppt.StartTime.Value = _appointment.Start myAppt.EndTime.Value = _appointment.End End Sub Public Sub Show() myAppt.Show() End Sub Private Sub Appointment_Open( _ ByRef Cancel As Boolean _ ) Handles _appointment.Open Cancel = True End Sub Private Sub myAppt_FormClosed( _ ByVal sender As Object, _ ByVal e As System.Windows.Forms.FormClosedEventArgs _ ) Handles myAppt.FormClosed _appointment.Subject = myAppt.Subject.Text _appointment.Body = myAppt.Body.Text _appointment.Start = myAppt.StartTime.Value _appointment.End = myAppt.EndTime.Value _appointment.Close(Outlook.OlInspectorClose.olPromptForSave) _appointment = Nothing End Sub End Class and then run it. To see the problem in action do the following, without restarting Outlook: 1) Open your calendar and create a new appointment, it will load your custom form. 2) Fill in the subject and body, and set the times if you like. 3) Close the form and save when prompted. 4) Using OWA, check that the appointment is there, with the times you specified. 5) Back in Outlook, move the appointment. Or better still, open again and change the times, subject and body. 6) Back in OWA, refresh your calendar and open the appointment. If you get the same results as me, then your OWA appoinment will have the updated subject and body, but not the updated times. If you restart Outlook and move the appointment, everything then seems fine. Can anybody help me Even if someone else can reproduce this problem and tell me I'm not crazy, it'll help! Thanks in advance, Ryan Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 15
    - When .NET objects dispose in Excel? Hi, all! As you know, it's possible to insert a control into Excel's worksheet. It's also possible to delete this object trough "Visual Basic panel" -> "Design Mode": just select desired .NET control and press "Del" button. But! Nor Dispose(), nor control's destructor would not be invoked. So the question is: How to manage .NET objects deletion For instance, my control connects to a server just after it been added, but when user deleted this control via "Del" button I couldn't close this connection. Any clues ideas solutions Thanks, /Dmitriy Tag: Visual Studio Tools for Office Word VSTO Issue. Office
  - 16
    - Event Handlers and UDFs in the automation add-ins Hi, Great ..thanks to this site for helping. I have an issue and have followed the following approach to create automation add-in. http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx . and created following code using System; using System.Runtime.InteropServices; using Microsoft.Win32; using System.Text; using Microsoft.Office.Interop.Excel; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; using System.Diagnostics; namespace lnzv2 { [ClassInterface(ClassInterfaceType.AutoDual)] public class wsf { Excel.DocEvents_ChangeEventHandler EventDel_CellsChange; Excel.Application xlApp; Excel.Workbook xlBook; Excel.Worksheet xlSheet1, xlSheet2, xlSheet3; public wsf() { myInitialization(); } public void myInitialization() { xlApp = new Excel.Application(); xlBook = xlApp.Workbooks.Add(Missing.Value); xlBook.Windows.get_Item(1).Caption = "XL Event Test"; xlSheet1 = (Excel.Worksheet)xlBook.Worksheets.get_Item(1); xlSheet2 = (Excel.Worksheet)xlBook.Worksheets.get_Item(2); xlSheet3 = (Excel.Worksheet)xlBook.Worksheets.get_Item(3); xlSheet2.Activate(); EventDel_CellsChange = new Excel.DocEvents_ChangeEventHandler( CellsChange); xlSheet1.Change += EventDel_CellsChange; // ........question1 } private void CellsChange(Excel.Range Target ) { Target.Value2=10;; } public int NumberOfCells(object Range) { int [,] TheValues = new int[1, 1]; TheValues[0, 0] = 1; TheValues[0, 1] = 2; TheValues[1, 0] = 3; TheValues[1, 1] = 4; Excel.Range r = Range as Excel.Range; r.set_Value(Missing.Value,TheValues);//......question2 return r.Cells.Count; } } } Given question1 I am unable to invoke the event.So please give me an idea how the event can be used and correct me if i am wrong. In question2 I am unable to get the value in the cells of the given range passes in the function and it gives an error in the cell where i have written the UDF =NumberOfCells(b2:c3). Please give a heling hand. thanks. Tag: Visual Studio Tools for Office Word VSTO Issue. Office

Murali.

Hello,

I created a VSTO Word 2003 Project with some webservices pulling in the data. I did the deployment using a setup project which worked fine. Suddenly I keep getting the error once the installer is run in client's computer and getting close to completion as "value cannot be null parameter name: url". This also happens unfortunately when I run the installer in my machine. I looked for any outdated references in the WebService but out of luck. Can you help me out with some ways and means to debug the installer when it is executed. I do not get any errors in the Visual Studio.Net 2005 nor on the set up project during compile time.Regmon did not help me either.

Thanks in advance.

Murali.

Re: Visual Studio Tools for Office Word VSTO Issue.

Cindy Meister

Hi Murali

any chance that more than one version of the .NET framework is installed on these machines

Re: Visual Studio Tools for Office Word VSTO Issue.

Murali.

Hi Cindy,

Yes, Initially the code was developed in a computer that had both frameworks installed. I then removed .Net 1.1 and recompiled the deployment project again.

Thanks,

Murali.

Re: Visual Studio Tools for Office Word VSTO Issue.

Murali.

I finally got the word vsto issue sorted out. Its just I flipped to a different machine that had .Net 2.0 alone and the set up worked fine.

Thanks cindy for your help.
Murali.