VSTO 2005 and VS 2005 Pro - how to get all features of both

Visual Studio Tools for Office

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

- Previous
  - 1
    - Performance/Display issues with Windows Forms I have a VSTO Add-in for Word 2007. It contains several windows forms - some small with few controls, some quite large with numerous controls. I have noticed two problem areas in testing my application, and hoping someone might have some suggestions: 1. When the form is displayed (using ShowDialog), it paints slowly - so you can see it "constructing" itself momentarily. In VB6, I was able to add a DoEvents immediately after calling Show(), which would cause the form to appear more suddenly. I am using SuspendLayout and ResumeLayout in all the right places, I believe. Are there any tricks to make the forms appear in a snappier fashion 2. One of my testers is having trouble with the forms going away when she clicks OK. She clicks OK and the form partially goes away but the majority of the form remains on the screen. She can display other forms (in other words, the 'ghost' fo the form still appears, but it doesn't keep her from performing other actions). The OK button does have the DialogResult of OK and also I have tried using Close() behind the button. This has happened to her both on her laptop and a different PC. I saw it happen for her, but it does not happen for me. Thanks for any help you can provide. PS - This behavior is occuring for both my small and large forms, so it doesn't seem to be specific to any one specific form in my app. kewpcg Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 2
    - VSTS with Office 2k3 I have VSTS (SP1) and office 2k3 (SP3) and I am trying to create my first word app but I am getting the following error: A compatible version of Microsoft Office Word 2003 is not installed on this computer. You must install Microsoft Office Word 2003 SP1 and the Visual Studio 2005 Tools for Office runtime I have already re-run the VSTO runtime patch but I am still getting the same error =( Here are the steps I am following: File-> New Proyect -> C#-> Office -> Word Document. Put a name: TEST. On the Select a Document for your app. dialog, I put: x Create a new document: test. I am new on this .. so any help is greatly appreciated =] Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 3
    - Office 2007 Quick Parts Hi, Is it possible ot access and create document's Quick Parts fields programaticaly Thanks in advance, Ivo Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 4
    - How to Import a .msg and .pst file into Outlook 2007 with C# code? I need to import .msg and .pst containers into Outlook 2007 using c#. I am aware of the CreateFromTemplate method, but this alters the message by saving it as an unsent email. I want to import the message items into Outlook without modifying them, just like if I imported them manually through the UI. I don't know Extended MAPI and was trying to avoid using Redemption if possible. If these are my only options, then I will deal with them, but I was hoping there was a third option. Does anybody have an example of some code, or know which methods I could use to accomplish this import using c# and the Outlook object model Thanks! Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 5
    - Error - InfoPath cannot open the selected form Hi, When I open VSTA and run my project show this message: InfoPath cannot open the selected form. Whats happen Im using InfoPath 2007!! Please Help me. Att Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 6
    - Multiple windows I've got an odd issue that I'm uncertain how to resolve. I'm running VSTO 2005SE with Office 2K3. I've added buttons to the toolbars that open windows. The odd thing is that when I click the button, it opens as many windows as there are powerpoint instances. I have no idea why a click in one instance causes the event to be run in all. I've tried setting it so that it checks to see if the window already exists but because they're being opened by separate instances, this does not work. Any recommendations would be appreciated. Thanks Denis --- www.21square.com Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 7
    - NamedRanges in Excel 2007 with VSTO SE When developing a document-customization addin for Excel 2003 with VSTO, adding a named range to a worksheets results in a Microsoft.Office.Tools.Excel.NamedRange inserted in the Sheet1.Designer.cs wich I can then reference from my code. The question is: when developing an application-level addin for Office 2007 with VSTO SE (as no document-customization project is available), how can I obtain a named range from code Suppose I create a range in the sheet from Excel by selecting a couple of cells and clicking the "Name a range..." item in the context menu. How can I then reference that range from code Is it possible to get a reference to a Microsoft.Office.Tools.Excel.NamedRange as it was in 2003 Thanks in advance, Sole Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 8
    - MAPI.SessionClass in Outlook 2007 Hi, Previously, I work with Outlook 2003 and install CDO in my machine. This code snippet was work in Outlook 2003. MAPI.SessionClass session = new MAPI.SessionClass(); session.Logon("", "", false, false, Type.Missing, Type.Missing, Type.Missing); session.Logoff(); Recently, I upgrade to Outlook 2007 and found out that MAPI was not in Outlook 2007 anymore, may I know how to replace the code snippet above using Outllok 2007 API. Regards Kendy Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 9
    - Outlook Appointments Hi I am sending appointments to Outlook from an application I developed in VS2005 as in( http://support.microsoft.com/kb/220595 ) This works fine for the default calendar. The question is how to send to a specific users calendar Thanks Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 10
    - Add TaskPanes in Office 2003 Hi, I spend last day trying to find a solution to add customs taskpanes in office 2003, Is this possible I'm using vsto 2005. I founded that office 2007 has the CustomTaskPane property....but for office 2003 didn't find nothing. Bye, Pedro Rocha Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 11
    - Support for multiple columns in Form Region controls Hi, I need to display data in multiple columns (like in a table) in a form region. I tried all Outlook.Olk* controls, none of them are suitable for my requirement. Neither "Grid" control is supported for form regions. 1)Could you please suggest me any other way to show the data in multiple columns 2)How to get the handle to this control in the function BeforeFormRegionShow() so that I can populate the values to this control Thanks. Regards, Rama Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 12
    - WindowActivate not being called My code adds a custom menu to Word documents in the WindowActivate method. My problem is that when a Word document is opened through Internet Explorer, the WindowActivate command is not called. Does anyone know what command is available for when a Word document is activated after opening it through IE I have found this documentation so far but nothing to resolve it... ---------------------------------------------------------- http://support.microsoft.com/kb/828087 Events are not raised in documents hosted in other documents or ActiveX containers Office documents contained in other documents using OLE might not raise events when they are activated or opened. Likewise, if an Office document is hosted in some ActiveX containers, it might not raise events. The only ActiveX container that is supported for hosting documents with managed code extensions is Microsoft Internet Explorer 6.x. If you open an Office document in Internet Explorer 6.x, the behavior for events raised in your managed code extension will be the same as those raised in a VBA project when the document is hosted in Internet Explorer. Due to the nature of ActiveX document hosting, some commands in the Excel or Word applications will be unavailable. Similarly, certain events are expected not to be raised when a document or workbook is contained in an ActiveX document host such as Internet Explorer (for example: in Word, mail merge events and Window events such as WindowActivate are not available; in Excel, you cannot cancel the close with the BeforeClose event handler). ---------------------------------------------------------- Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 13
    - building outlook toolbar in contacts I can use the below code to create a toolbar in outlook: try { // See if it already exists this .toolbarButton = (Microsoft.Office.Core. CommandBarButton )commandBars[ "Standard" ].Controls[ "SE Dial Contact" ]; if (applicationObject.ActiveExplorer().CurrentFolder.FolderPath.EndsWith( "Inbox" )) { this .toolbarButton.Visible = false ; } } catch ( Exception ) { // Create it this .toolbarButton = (Microsoft.Office.Core. CommandBarButton )commandBars[ "Standard" ].Controls.Add(1, System.Reflection. Missing .Value, System.Reflection. Missing .Value, System.Reflection. Missing .Value, System.Reflection. Missing .Value); if (applicationObject.ActiveExplorer().CurrentFolder.FolderPath.EndsWith( "Inbox" )) { this .toolbarButton.Visible = false ; } this .toolbarButton.Caption = "SE Dial Contact" ; this .toolbarButton.Style = Microsoft.Office.Core. MsoButtonStyle .msoButtonCaption; } but I want this toolbar to be created in each contact in outlook (when user double clicks a contact).... how is this done Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 14
    - Before an Appointment item is saved, how can I get the occurrences specified by the recurrence pattern? I am trying to create code behind a custom form in Outlook. It is a customization for the AppointmentItem form. On the custom tab we have a C# User Control. Within the control, I have a need to get all of the occurrences of the appointment specified by the recurrence pattern, if one exists. So, based on some user action on the control, I am trying to get a list of dates that the appointment will fall on. The problem is, when I call GetOccurrence on the recurrence pattern of the item, I get an exception "You changed one of the recurrences of this item, and this instance no longer exists. Close any open items and try again." What am I missing here Any help would be appreciated. Example code: private void button1_Click(object sender, EventArgs e) { List<DateTime> lsStarts = new List<DateTime>(); List<DateTime> lsEnds = new List<DateTime>(); Outlook.Application app = new Outlook.Application(); Outlook.Inspector insp = app.ActiveInspector(); Object item = insp.CurrentItem; Outlook.AppointmentItem apptItem = item as Outlook.AppointmentItem; LoadDateLists(apptItem, lsStarts, lsEnds); // continue, i.e. check availability of selected resource for the dates of the appointment //ShowDates(lsStarts, lsEnds); } private void LoadDateLists(Outlook.AppointmentItem item, List<DateTime> lsStarts, List<DateTime> lsEnds) { lsStarts.Clear(); lsEnds.Clear(); if (item != null) { if (item.RecurrenceState == Microsoft.Office.Interop.Outlook.OlRecurrenceState.olApptNotRecurring) { lsStarts.Add(TimeZone.CurrentTimeZone.ToUniversalTime(item.Start)); lsEnds.Add(TimeZone.CurrentTimeZone.ToUniversalTime(item.End)); } else if (item.RecurrenceState == Microsoft.Office.Interop.Outlook.OlRecurrenceState.olApptMaster) { Outlook.RecurrencePattern recurPattern = item.GetRecurrencePattern(); for (DateTime dt = recurPattern.PatternStartDate; dt < recurPattern.PatternEndDate; dt = dt.AddDays(1)) { try { // THE FOLLOWING LINE CAUSES EXCEPTION: // You changed one of the recurrences of this item, and this instance no longer exists. // Close any open items and try again. Outlook.AppointmentItem oItem = recurPattern.GetOccurrence(dt); if (oItem != null) { lsStarts.Add(TimeZone.CurrentTimeZone.ToUniversalTime(oItem.Start)); lsEnds.Add(TimeZone.CurrentTimeZone.ToUniversalTime(oItem.End)); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { // to do: Unhandled condition in LoadDateLists, item.RecurrenceState == " + item.RecurrenceState.ToString() } } } Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 15
    - Outlook 2007 RTM FormRegion & InfoPath control Thanks for your reply (sorry I didn't see it sooner). The basic form region is made up of the standard to, cc, subject, and message fields and then an InfoPath control at the bottom. The form region is a "replacement" form as opposed to a partial region that exists in another form. Using the simplest repro method, have the add-in cause the InfoPath control to create a new form using a template (we open a File Open dialog to get the template but you can hard-code it for your tests). Once the form region (as its own form since it is a replacement form region) is open, you can tab to all of the controls except the InfoPath control. You can click (with a mouse) into a field in the InfoPath control, but if you press tab, you will leave the control and go to the next Outlook field. I believe you should be able to tab into the InfoPath control and then remain there until you click out of it (in other words, the InfoPath control should process all keys while it has focus). Let me know if you need more information. Pete Loveall Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 16
    - Conditionally create multiple MS Word documents based on a single, master MS Word doc? I want to conditionally create multiple MS Word documents based on the same master MS Word document. Example: I have a single MS Word document with say 100 sections. I want to create 4 different MS Word documents, which include a different subset of the sections from the master document. I know I can do this today by manually copying and pasting, but this is error prone and time consuming. I am looking for a solution where I can somehow tag the different sections in the master document and then somehow provide a parameter value which indicates which sections (based on their associated tags) should be stripped and which should be kept in the resultant document. I experimented with the MS WORD mail merge feature - but it's insuffience to archieve the above result. Please let me know if the above can be achieved with the vanilla MS WORD product, and if not what commerical Word add-ons do you recommend Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
- Next
  - 1
    - outlook toolbar in sent messages Hi all, i have created a toolbar that loads a commandbar into outlook when it loads, using Code Snippet Office.CommandBar newToolBar; Office.CommandBars cBars =this.Application.ActiveExplorer().CommandBars; newToolBar = cBars.Add("myBar", Office.MsoBarPosition.msoBarTop, false, true); (with some other stuff), and it loads into the main outlook screen fine.... However, I would like to have these buttons in the toolbar when I open up a message. i.e. open outlook, open a message, press toolbar button. HOw do I install the button/toolbar into that screen thanks michal Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 2
    - Creating a formatted Microsoft excel file. Hi, How can you create formated excel files through a program. By formatting, i mean individual cell background colors, row widths, column heights.. and stuff. Thanks in advance. Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 3
    - Printing Range of Pages prints in a 20 page document, prints it 20 times It is a 20 page document. object pageRange = "1,3,5,7,9,11,13,15,17,19" object PrintRangeOfPages = Microsoft.Office.Interop.Word. WdPrintOutRange .wdPrintRangeOfPages; object PrintDocumentContent = Microsoft.Office.Interop.Word. WdPrintOutItem .wdPrintDocumentContent; object PrintAllPages = Microsoft.Office.Interop.Word. WdPrintOutPages .wdPrintAllPages; Document .PrintOut(ref BooleanTrue, ref MissingValue, ref PrintRangeOfPages, ref MissingValue, ref MissingValue, ref MissingValue, ref PrintDocumentContent, ref pageRange, ref PrintAllPages, ref BooleanFalse, ref MissingValue, ref MissingValue, ref BooleanFalse, ref MissingValue, ref MissingValue, ref MissingValue, ref MissingValue); Please advise if I am doing something wrong. shrini Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 4
    - Disable VSTO toolbar when cell is being edited When you start typing in on a cell, Excel 2003 disables some standard toolbar buttons. How can I achieve the same effect for my VSTO toolbar buttons. I've looked for an event such as ThisWorkbook.CellStartEdit, but there seem be be none that matches what I'm looking for. Thanks. Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 5
    - Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Has anyone tried to follow along with the new article on "Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2)" The article is here: url:http://msdn2.microsoft.com/en-us/library/bb332051.aspx About half-way through Part 1, the following instructions appear, leaving me perplexed: Preparing the Office Component Check Compile the Office component checker sample for the primary interop assemblies redistributable packages Important: If you are using VSTO 2005 SE in conjunction with VSTO 2005, ensure that you have installed both the .NET Framework 2.0 software development kit (SDK) and the Windows SDK. Here's my question: Which Windows SDK should I install I'm running VSTO 2005 SE with VSTO 2005 on WinXPSP2. I assume that I should install a Windows SDK specific to WinXPSP2, but I can't figure out what file that would be I can find Platform SDKs for Vista and WinServer 2003. Should I be looking for a "Platform SDK" for WinXPSP2 Or should I be looking for a "Windows SDK" as listed in the article Where can I find the SDK -- Bill Coan billcoan@wordsite.com Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 6
    - How to store meta-data in Outlook 2007 I am developing an Outlook plug in where I have to store meta-data in Outlook for the customizations user does. How to store meta-data in Outlook without persisting to the user (and) without storing in different file(like xml file) I did research on table object. But, I think it doesn't help me out because it is read only object. Please let me know if u have any ideas I am using VSTO SE/ Outlook2007 /VS 2005/C# Thanks, Rama Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 7
    - A strange problem in retrieving a file path and creating a button in Word Hi I don't have a lot of knowlege in COM so the problem that I encountered was very strange to me. I'm trying to create a button in my Word appliction through a Shard Addin project in C#. When I'll press this button a certain logic that I wrote will be executed. I encountered two problems. 1) I can't create the button in my Word application but only in my outlook and I don't know why. I followed exactly the code that's written here: http://support.microsoft.com/default.aspx scid=kb;en-us;302901 But the button was not created. I Added the right assemblies for Word and Office and the CheckBox for "Register for COM interop" was checked. I tried to install all of office components again but it still didn't worked Then I tried to check whether the Addin workd at all so I wrote a messageBox in the OnStartupComplete to see if the MessageBox shows-up. The MessageBox - MessageBox.Show("Hi") - only shows up in Power Point and Outlook. Not in Word or Excel. 2) After the button will be clicked I want to retrieve the path of the current Word Document that's running. Since I couldn't do it with Word, I tried to do it with "Power Point" just to see that it works. I created a string variable that holds the path of the current object according to the code that I found here in a similar question. I checked to see if the file path was retrieved by setting one of the MessageBox parameters with the string value of the path: Type CurrentApplicationType = applicationObject . GetType (); object ActiveDocument = CurrentApplicationType . InvokeMember ( "ActivePresentation" , System . Reflection . BindingFlags . GetProperty , null , applicationObject , null ); ActiveFilePath = ( string ) ActiveDocument . GetType (). InvokeMember ( "FullName" , System . Reflection . BindingFlags . GetProperty , null , ActiveDocument , null ); MessageBox . Show ( "ActiveFilePath" , ActiveFilePath ); The result was that the MessageBox doesn't show up at all. It does shoes up when I write a regular MessageBox - MessageBox.Show("Hi"). Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 8
    - Word automation from a Web Service With current (i.e. pre Word 2007) versions of MSWord, there are problems attempting to use WORD automation on an unattended server. The main ones are: WORD is not thread safe. Trying to start more than one instance can crash you. This results in very limited throughput if you are trying to do higher volume WORD can open "pop-up" error dialogues at any time, effectively hanging the app until some form of intervention occurs. Microsoft strongly recommends that you not implement server based automation. Thats great, except in many cases there is no other way to do what you need to do! So my question is whether Word 2007 solves these problems, and whether that makes use of WORD 2007 in a server based application an viable option I am specifically looking at a "document rendering" web service. We have a document management database with a few terabytes of documents, much of it in MS Word documents. I need to be able to render a WORD document to PDF to enable it to be displayed on our web portal. It sounds like Words 2007 "Save to PDF" is just what I need. So I am visualizing development of a web service which will accept a request to render a document, retrieve it from the database, use VSTO to load the document and automate the "save as PDF" ,and take the resulting PDF document and return it as the web service response. IF this approach doesn't work, I am looking at having to purchase some fairly expensive commercial software products that do the same thing, but use multiple workstations and instances of Word (to get around the threading / stability problems)....a kind of complex and expensive solution... (note my go live date is in 2007, so the time frame for Office 2007 would work for me, if the architecture is viable) Can anyone give me an idea of whether it would be viable to pursue a Word 2007 based solution Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 9
    - Deployment path setting Hello, I've developed an addin for Word 2007 using VSTO 2005 SE. For the setup file, I'm using the default setup file when I created the project. My question is, how can I set a default installation folder for my addin For example:- When the setup file launched, I want to make the *.msi file to automatically install the addin to a predefined folder. It means that no user interaction required, no need to choose an installation path and no clicking needed. Just a direct installation like the MS Office 2007 PIA msi setup file. Can it be done Hope someone can help me about this. Regards, Westman Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 10
    - Adding images to home-made context menus Hi, I'm working on a VSTO 2005 SE add-in for Word 2007 that add items to the context menu. My problem is that I didn't manage to add images to my new context menu items. Here's my code to add an item to the context menu (here, the "Text" context menu) : Code Snippet Dim myContextMenuItem As Office.CommandBar Dim btn As Office.CommandBarButton myContextMenuItem = app.CommandBars("Text") btn = myContextMenuItem.FindControl(Office.MsoControlType.msoControlButton, , Caption) If (btn Is Nothing ) Then btn = myContextMenuItem.Controls.Add(Office.MsoControlType.msoControlButton, , "" , pos, True ) btn.Caption = Caption btn.Tag = Caption btn.Style = Office.MsoButtonStyle.msoButtonCaption btn.Visible = False End If I guess I should use the Picture property. So I added the following line : btn.Picture = GetImage("myImage") Where GetImage is declared like this : Code Snippet Public Function GetImage( ByVal imageName As String ) As stdole.IPictureDisp Dim bitmap As Bitmap bitmap = My .Resources.ResourceManager.GetObject(imageName) Return PictureConverter.ImageToPictureDisp(bitmap) End Function And PictureConverter is a friend class : Code Snippet Friend Class PictureConverter Inherits AxHost Private Sub New () MyBase .New( String .Empty) End Sub Public Shared Function ImageToPictureDisp( _ ByVal image As Image) As stdole.IPictureDisp Return CType (GetIPictureDispFromPicture(image), _ stdole.IPictureDisp) End Function Public Shared Function IconToPictureDisp( _ ByVal icon As Icon) As stdole.IPictureDisp Return ImageToPictureDisp(icon.ToBitmap()) End Function Public Shared Function PictureDispToImage( _ ByVal picture As stdole.IPictureDisp) As Image Return GetPictureFromIPicture(picture) End Function End Class Unfortunately, this doesn't work. There's no crash, but there's no picture in my context menu item. Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 11
    - Adding a large amount of contacts I've hit a road block. I am writing a .NET Outlook (2003) plugin to update my users contacts from a database that our clients update. I have managed to get the plugin button up, and clicking on the button gets the contacts and starts adding them. However, the code has added the 249th contact item, I start getting First Chance exceptions. Is there some kind of restriction that stops me from adding more contacts This is a huge issue for new users in the group, becuase we have over 5000 email address that need to be pushed out to the Contacts Folder. Here is my code for adding the contacts. Please tell me if I am doing something wrong or if there is a restriction: foreach ( DataRow dr in dt.Rows) { try { Outlook. ContactItem ci = (Outlook. ContactItem )newcontacts.Items.Add( Outlook. OlItemType .olContactItem); ci.CompanyName = dr[ "CustomerName" ].ToString(); ci.FullName = dr[ "ContactName" ].ToString(); ci.CustomerID = dr[ "CustomerNumber" ].ToString(); if (dr[ "ContactNumber" ].ToString() != "" ) ci.BusinessTelephoneNumber = dr[ "ContactNumber" ].ToString(); ci.Email1Address = dr[ "ContactEmail" ].ToString(); ci.Save(); } catch ( Exception ex) { Console .WriteLine(ex.ToString()); } Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 12
    - Attaching custom actions Pane to all documents !!! Hi All, After reading quite a few posts and trying out various shortcuts or hacks to acheive an " Application Level Task Pane " for Word 2003, i have really come to a grinding halt !! few of the paths that i followed were 1. Tried to modify the XML of a WORD document by adding the _AssembleName=* and _AssemblyLocation custom document properties.... I am now trying to acheive this by Attaching Managed Code Extensions to Documents...still work in progress i guess my question would be that in one of these posts Misha Shneerson did point out that it was possible to attach a task pane at an Application level but could only be acheived by someone like her who knows the internals of ActionsPane and VSTO and that it wasnt for the *****Faint Hearted***** .... still trying to locate that post... so if any one could point me in the right direction or suggest an alternative, that would be great !!! I know that Custom Task panes are possible in word 12/ 2007... but i def. require to achieve this with word 2003 / Office Pro edition... as our target audience is not likely to move to office 2007 for quite some time !!! If i haven't been clear please do ask for clarifications !!! tha, koms Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 13
    - Convert a selection and convert it to rtf Hello all, Is there any way to take a selection from MS Word using VSTO, and convert that selection to rtf Right now here is the code which uses the clipboard: private string ConvertToRTF(Word. XMLNode node) { string strData = "" ; try { // Copy to clipboard (This will erase the clipboard contents that the user entered into here before!!! node.Range.Copy(); strData = Clipboard .GetText( TextDataFormat .Rtf); Clipboard .Clear(); } catch ( Exception ex) { Trace .WriteLineIf(logic.ASI3Reporting.TraceError, "Error converting to rtf: " + ex.ToString(), "Errors" ); string ss = ex.ToString(); } return strData; } The problem with the code is that the clipboard contents are now replaced with my selection thus replacing the value at the top of the clipboard stack so the end user won't have their original copied data. I need to copy this because this is the only way that I can get the selection converted to rtf. Another method would require saving the entire document to disk as rtf but this would only work for the entire document, whereas, I need to convert only a selection. Any help would be greatly appreciated. Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 14
    - ComboBox on an Outlook PropertyPage doesn't seem to get DrawItem events I want to display several ComboBoxes on an Outlook PropertyPage. I want the ComboBoxes to display icons and text. I've tried two approaches to this: Setting the draw mode of a standard ComboBox to DrawMode.OwnerDrawFixed and then setting a DrawItem callback. However the callback never gets called. I then tried extending the standard ComboBox class that sets the draw mode in the constructor and overrides OnDrawItem. This method never gets called. I can only conclude that the DrawItem event never gets fired. Is this something to do with the ComboBox being inside a PropertyPage Any suggestions on how this can be resolved Many thanks, Ben Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 15
    - ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Hi, I have upgraded a Excel VSTO 2003 solution to VSTO 2005. Now, I am about to deploy this to my end-users. However, I need to automatically migrate the existing Excel workbooks created which refer to the 2003 Solution (via _AssemblyName0 and _AssemblyLocation0 custom properties) to use the new 2005 solution. I realize this involves embedding a Runtime Storage Control activeX component within the Excel document. Therefore, I employed a technique provided by MS as part of a solution called ApplicationManifestEditor. Essentially, it tries to add the Runtime Storgage Control to a document by using the ServerDocument.AddCustomization(...) method. Unfortunately, when I try this methodology I get an COMException as shown below. The parameters I am passing to the AddCustomization method are: documentPath = "C:\MyDirectory\OldExcelWorkbook.xls" assemblyName = "C:\MyVSTO2005Solution\MyAssembly.dll" manifestPath = "" applicationVersion = "1.0.0.0" makePathsRelative = true / false (tried both). Could you please assist me in resolving this issue Thanks, Tim System.Runtime.InteropServices.COMException (0x80040407): Exception from HRESULT: 0x80040407\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.IAppInfoDocument.SetDocument(String fileName, Byte[] bytes, FileAccess access)\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.GetOfficeDocument()\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.EnsureDocument()\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.WriteItem(String element, String id, Byte[] item)\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.AppInfo.WriteManifest(IAppInfo appInfo, String manifest)\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.Customizer.CustomizeDocument()\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.Customizer.Customize()\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.ServerDocument.AddCustomization(String documentPath, String assemblyName, String deploymentManifestPath, String applicationVersion, Boolean makePathsRelative)\r\n at ApplicationManifestEditor.ApplicationManifestEditor.AddCustomization(String fileName) in D:\\Data\\Visual Studio Projects\\ApplicationManifestViewer\\CS\\ApplicationManifestEditor\\ApplicationManifestEditor.cs:line 504" string Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office
  - 16
    - Support for multiple columns in Form Region controls Hi, I need to display data in multiple columns (like in a table) in a form region. I tried all Outlook.Olk* controls, none of them are suitable for my requirement. Neither "Grid" control is supported for form regions. 1)Could you please suggest me any other way to show the data in multiple columns 2)How to get the handle to this control in the function BeforeFormRegionShow() so that I can populate the values to this control Thanks. Regards, Rama Tag: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both Office

markco2

Sorry if the answer is already out there and obvious but I can't find it and need to make a purchasing decision:

I'm using VS 2005 Team Suite Trial Edition. I don't need all that this version has to offer. Basically I want VS 2005 Pro with full VSTO capabilities. I understand that VSTO SE will help but doesn't offer full capabilities. I also need the capabilities in VS 2005 Pro that aren't in the VSTO version.

From a purchasing standpoint the most cost effective way to go seems to be to buy VS Pro with MSDN Pro subscription to get both. Does this make sense

Thanks in advance for your information.

Top

Re: Visual Studio Tools for Office VSTO 2005 and VS 2005 Pro - how to get all features of both

Robert Green

To get VS 2005 Pro with full VSTO capabilities you have two choices:

1. Buy VS 2005 Pro and then buy VSTO 2005. Two different boxes.

2. Buy an MSDN Pro subscription, which includes VS 2005 Pro and VSTO 2005.

I agree with you. The MSDN Pro subscription is the way to go.

Robert

Top