Office Edition required for VSTO SE

Visual Studio Tools for Office

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

- Previous
  - 1
    - Newbie VSTO deployment Hi Michal, Yes -- there are a lot of preparation steps for your environment as part of the deployment article. Although it doesn't help you now, the next version of Visual Studio Tools for Office will use Click Once as the deployment model. Thanks and regards, Darryn Lavery [MSFT] Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 2
    - Outlook CRM Integration AddIn That is correct. VSTO does not like two version of office installed on the same machine. One easy way to solve this problem is to run Office 2003 inside of a virtual machine. In this way you can have both running on the same machine without any conflicts. As a consultant I work for many clients. I started using Virtual machines because each client has a different configuration. With Microsoft VM I can create one base hard drive and then create differencing disks for each client. In your case you can just create a single disk with Windows XP, Visual Studio 2005 and Office 2003. Alternatively, to do what you want without installing Office 2003, you can create a VSTO project for Outlook 2007 and then just open and import the .cs or .vb files (excluding any VSTO generated code) into your new project. Al Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 3
    - Item_delete event of appoinment Hello Sue, I don't think so, because it is programmed only for selected Items. But - a bad Trick would be to let the user delete the Item, then it goes to the deleted folder. Then maybe you can restore it on the fly. However - doesn't work for Shift-Delete. But here you can use the Key-Handler - you have a sample for this on your site. Should I investigate a little bit time in this problem Greets, Helmut Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 4
    - Assembly Info Missing Well you forced me to go looking for it. I don't have VSTO installed on either of my VS2005 builds. On my VS2008 build it is in the GAC. Since VS2008 should be using the same version as VS2005 you should look there. I believe I remember that VS2005 shipped with support for Office 2003 so you have to download the VSTO for later versions of Office. It might be in there. The design time component, FYI, is in <VSDir>\Common7\PublicAssemblies. As for the spellchecker I don't really know. There are third-party vendors who have controls for spellchecking in textboxes that you could use. Then again Word does already have that as well so using COM to load up Word to spellcheck, while overly complex and perhaps wasteful of resources, would work. I know that I've seen that done in an app or two. If this is for a home project or something then you should be okay as you won't notice but if you were to drop this into a commercial app it might not work so well. You'll have to play around with it to verify it works the way you want. The other thing to consider is the dictionary. If you attach yourself to Word then the user's Word dictionary is used for spell checking. This might or might not be what you wanted. If the user wants to add more words to their dictionary they would have to go to Word or you would have to extend your app to expose Word for this. If you are not interested in really using Word's dictionary then writing a spell checker isn't that hard. It is just a comparison of all words not in a list. The difficulty comes in doing it efficiently and for ignoring things like proper nouns, those containing numbers, etc. As for Vista, business is still around. I have it on my company notebook. Ultimate is nicer if you have the hardware to run it. Enterprise is nice too if you have a license for it. Ultimately they are all the same code base (and in fact the same install). Changing the product key changes the version you have and the options available. One thing about Vista I should warn you about (beyond everything you've read) is that searching for files is all but futile. You either have to waste space and CPU usage on indexing the entire system or live with the fact that it'll only search documents. Hence searching for assemblies or source files with certain entries is all but useless. Beyond anything the new search in Vista is horrible. That's why I can't say for certain whether I have the VSTO stuff on my VS2005 machines or not. I can't search for the assembly without indexing my entire drive and it won't find it reliably without indexing. Michael Taylor - 10/22/07 http://p3net.mvps.org Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 5
    - VSTO and Outlook Web Access (OWA) I wouldn't consider adding some folders to be a modification of the client interface. That's a change to the data being stored and, thus, would be reflected in OWA if the folders are in the Exchange mailbox. Correct: VSTO has nothing to do with OWA. Exchange development docs start at http://msdn.microsoft.com/exchange/ with discussions in the microsoft.public.exchange.development newsgroup. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 6
    - Publishing a VSTO Project to a Server without FrontPage Server Extensions I must publishing a VSTO 2005 Project (Word 2003 document level add-in) to a server without FrontPage Server Extensions (actually an Apacher server, but never mind...). Obviously this does not work out of Visual Studio. How do I go about to deploy my VSTO solution to the server, in such a way that later updates to the solution will work as well Do I need to set up a deployment project But how ! --adrian. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 7
    - Use Outlook 2003 to send meeting request using c# You already answered your own question: You need to build an Outlook COM add-in. Since you can't use VSTO, you need to use the IDTExtensibility2 (shared add-in) interface. If you derive all Outlook objects from the Outlook.Application object passed as an argument by the OnConnection event, properties and methods of those objects won't trigger security prompts. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 8
    - Show the savdialog after DocumentBeforeSave Sorry - When I set the visible = false it hid the dialogbox I wanted to, but it also minimized word.... The only thing displayed was the saveFileDialog... Thats no good.. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 9
    - new to visto.. please help Hi all, I am new to VISTO and really appreciate if some one could help on the following issues. I am working a Excel appliaction that uses a c# dll to get data from a java server using http client. I've used a VBA addin ( xla file) for menus and some basic operations. After the user sing on , I create a object as, Set mobj = CreateObject("MyDLL.ClassName") and start using obj in VBA. I wanted to move to VISTO and make use of the custome Taskpane control. so I created a excel project and I want to use the active instance created in VBA. Can I do this . I tried system.runtime.interopservices.marshal.getactiveobject("mydll.classname") and didn't work. Also, VISTO added a class called thisworkbook.cs. The C# dll has a reference to the Excel application and refers to thisworkbook ( Excel's ) in many code. How to handle this Please help. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 10
    - Add transparent icon to workbook programmatically Exactly which commands are you using in Excel (you say "clicking in Excel" in your first message) Please be very precise about the steps you're using in the UI. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 11
    - VSTO w/o Excel and Outlook The PIA Check takes a GUID command-line parameter. You pass it the various GUIDs of the office applications you want to check if the PIAs are already installed. If you are just wanting to check Word, you would call it as follows: PIACheck.exe {1C8772BD-6E6F-4C9D-8FF8-B5EA072F86EF} If the PIAs for Word are installed then the check returns zero (0). If they are not installed, then the check returns a non-zero value, and you'll want to install the office PIAs. AppCheck.exe works much the same, if you are just wanting to verify that the target machine has Word, you would call Appcheck as follows: Appcheck.exe /word Here, Appcheck returns zero (0) if Word is installed and a non-zero value if word is not installed. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 12
    - Adding Custom Document Information Panel Thro' C# Hi All, I am facing following problem in C#.NET, if anybody have any suggestions or idea then please let me know.. Problem Definition: I am using word 2007 and C#, My task is to add a Custom Document Information Panel through c#. means in word 2007 there is a Developer Ribben that there is a Document Panel which is used to load a custom Information panel...so is it possible to add it through c# coding... Thanks Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 13
    - axSpreadSheet1 Hello, Can someone help me to set a color to a specific cell in as SpreadSheet1 using SpreadSheet1 that is embedded in C# is that possible to change also the colomn name in SpreadSheet1 (ex "A" column to another value) Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 14
    - Removing editing restrictions After the document is protected, if you want to remove the restrictions, you should use Range.Editors.Add() method. Like the following codes: Code Block object everyoneEditor = Word. WdEditorType .wdEditorEveryone; app.Selection.Editors.Add( ref everyoneEditor); Thanks Ji Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 15
    - Copy-paste office documents via clipboard Hi, The FileDrop format is for doing shell drops and Word does support it (as does Excel). The format consists of a string array containing fully qualified file names. When Word receives a clipboard object of this format, it walks the the array and opens each file. Here is an example of how to use it: object data = new string [] { @"C:\test.txt" }; Clipboard .SetDataObject( new DataObject (System.Windows.Forms. DataFormats .FileDrop, data)); Word. Selection selection = this .Application.Selection; selection.Paste(); If you want to actually place the raw file bits on the clipboard, you are limited by the formats that Word understands. Your best bet would be to read the file into a string and use UnicodeText (or Text). Alternatively, you could use RTF (Rich Text Formatting) if you wanted to have some formatting. However, if your file isn't already RTF, it would require some effort to build an RTF blob. Sincerely, Geoff Darst Microsoft VSTO Team Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 16
    - Outlook undo statck Hi DoWang, another Trick could be to Execute the Undo-Button. The Id of the Undo Button is 128 So it could be something like this (Sorry - Proof of concept VBA code) Sub UndoLastAction() Dim ctrl As CommandBarButton Set ctrl = ActiveInspector.CommandBars.FindControl(ID:="128") ctrl.Execute Set ctrl = Nothing End Sub Hope this helps, greets, Helmut Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
- Next
  - 1
    - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) In that case, I recommend you go with this question to the office.developer.automation newsgroup. This forum is specifically targeted at the VSTO technology, and not at general Office automation. The error you reported was known to me, under the described circumstances, but if something else is causing it, you'll have a better chance getting answers in the newsgroup interface. http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US You might also try searching the Knowledge Base on the phrase: RPC server Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 2
    - SaveCopyAs() functionality that exists in Excel object in Word object Hello, I would like to give a little bit of background relating to my problem before I ask the question, but it can be skipped . ========Back ground=========== We have created an Office addin that works with both Excel and Word. As part of the functionality of this addin we would like to take the current data that is on the user's screen in either of these applications and store it to a completely new file when they click one of our addin's buttons (lets call it 'Copy My Work' button). In Excel, there is this method directly on the ActiveWorkBook object called 'SaveCopyAs(...)'. This is great because if the user opens an existing excel file (.xls) and makes changes to it, then clicks our 'Copy My Work' button, it will create a brand new xls file with whatever the user has in that file without forcing the user to save their changes to the existing file. Example: User opens original.xls, makes changes but hasn't saved the changes. User clicks our button, newfile.xls is created and it contains the changes. original.xls is still unsaved. This is thanks to the magic of SaveCopyAs(...). We would like to do the same thing for our add in for Word, however, I don't see this awesome method on the ActiveDocument object. My only choices are Save(..), SaveAs(..), SaveAs2000(..). We currently get it around this by saving the file and then making a copy of it but this is far from desired, ultimately our goal is to have the addin work exactly as it does in Excel and not force the user to save their changes and still have those changes be picked up when they click our button. =====End Background===== So, my question is, how can I replicate the SaveCopyAs(..) functionality that exists in the Excel.ActiveWorkbook object, in the Word.ActiveDocument object I am using c#, and this add in is being programmed against office 11 (2003). Thanks, Ryan Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 3
    - Debugging Problem We had this expierience when we have had various beta versions and previous versions of Visual Studio on the same machine, have you got VS 2003 I did a complete rebuild to fix this but did think was an issue that was stemmed from VS2003 and VS2005 tool set on the same machine. Regards Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 4
    - Stroing additional data along with a cell Hi Sameera, Only problem with that is we'd be dealing with tables that are of 100s or 1000s of records. But, still that can work If You today use comments through the built-in UI then You face the same problem when it comes to the number of rows information. I would go with this approach and provide a user friendly UI to view/edit the additional information. Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 5
    - COM object with CLSID {...} is either not valid or not registered. Hi all, I am facing the following problem on logout from outlook using this line of code. this.olApp = new Outlook.ApplicationClass(); this.olNS = olApp.GetNamespace("MAPI"); ...... some code goes here... this.olNS.Logoff(); // this line generates this error COM object with CLSID {4A5E947E-C407-4DCC-A0B5-5658E457153B} is either not valid or not registered. Exception Type = "System.Runtime.InteropServices.COMException" I have outlook 2003 with SP 2 installed on 1 machine while exchange server is on the other machine so no issue regarding outlook and exchange on same machine. Can anyone help me out here Please Its urgent.... Kind Regards M.Z.K Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 6
    - How can I insert empty checkbox and ticked-checkbox into a word document, using C#. Hi Cripto, You can change the below four lines to: Application.Selection.MoveRight(Unit:=Word.WdUnits.wdCharacter, Count:=1, Extend:=Word.WdMovementType.wdMove) object unit = Word. WdUnits .wdCharacter; object count = 1; object extend = Word. WdMovementType .wdMove; this .Application.Selection.MoveRight( ref unit, ref count, ref extend); Thanks Ji Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 7
    - Can ContentControls be bound to a collection of Nodes? Cindy, Thanks for your reply. Your comments were extremely helpful! Shirish Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 8
    - Adding an Image to the shapes collection Thank you guys. The filestream thing really works. And its faster than I expected and there is not a problem, yet! Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 9
    - caspol error Can you be more specific about the error you are seeing when opening the template Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 10
    - Question regarding Addin Event Handlers I dont think you could declare as static but as the Explorer selection changes you would still have a reference in memory to the time this item was ran. Therefore currentlySelectedMailItem would be defined the first time and any even on that item would then be fired as required but I would not get too rich in loads of events as they scroll through the explorer and work on the action against the explorer and then on a new Inspector window then register this in a collection and register the events. Regards Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 11
    - Is there a different in VSTO 2007 and VSTO 2005? what do you mean by document-level customization does that means that i cannot create custom control which will do formatting on my selected text on word 2007 Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 12
    - VSTO Powerpoint screen drawing issue Pl refer the above discussion. I have the same prolem. The moment I load the add-in I developed, the pictures etc do not get refreshed. Could some body advise how to resolve the problem Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 13
    - Publishing VSTO 2005 SE addin to a network location Hi Denis, Thanks for the response. This seems to be a feasible solution. Just a few doubts, do you mean that the new application will kill all the instances of the host office application and then copy the required dlls. Also, will replacing the local copy with contents of the publish location activate the latest version or will we have to make some changes in the registry settings as well Would be great if you can share some details of what you did in the application launched. Thanks and Regards, Rakesh Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 14
    - Should I be using SE? There's a typeo on your first line: /assemblyName="Closed_Loans _Report_Queue.dll" /targetDir="[TARGETDIR\" Should be: /assemblyName="Closed_Loans _Report_Queue.dll" /targetDir="[TARGETDIR]\" That would be one problem ... Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 15
    - Custom toolbar ONLY for Inspector Windows I believe what you are missing is Handles allInsp.NewInspector at the end of the event declaration. It should look like this: Private Sub allInsp_NewInspector( ByVal Inspector As Microsoft.Office.Interop.Outlook.Inspector) Handles allInsp.NewInspector MessageBox.Show( "HELLO WORLD!" ) End Sub Hope this helps, Mike Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office
  - 16
    - Shared Add-In + Custom Task Pane : How to access host application? Somebody help me please, I'm going crazy with this thing! I have a custom task pane that I want to use in Word, Excel and PowerPoint, so by my understanding it should then be loaded with a shared add-inn. I have followed this screencast as a starter: http://channel9.msdn.com/ShowPost.aspx PostID=197654#197654 The problem is, in this screencast they only use Word.... It's a SHARED add-inn so atleast they could have shown me how to make it work with word and another office application, but that is not the case. The way this works is that there is a Connect class that loads the add-inn and shows the task pane, but I can't work with this class at all! It doesn't offer any methods, properties or anything. So how do I know if the task pane is running in Word or Excel In the screencast they typecast the applicationObject to Word.Application, in the Connects OnConnection method, which I guess is fine if it only runs in Word, but this obviously will crash if I load the taskpane in Excel... How can I test for the type of applicationObject and cast it to the right type And then, how do I actually access this applicationObject from the task pane Typing the namespace.classname only gives me the Equals() and ReferenceEquals methods since this is just an object type=( This is driving me crazy and holding up my project. Here's some code so you hopefully will get an idea of the problem: Code Block namespace AxessRibbon { using System; using Extensibility; using System.Runtime.InteropServices; using Word = Microsoft.Office.Interop.Word; using Excel = Microsoft.Office.Interop.Excel; using PowerPoint = Microsoft.Office.Interop.PowerPoint; using Microsoft.Office.Core; using System.Resources; using System.Reflection; using System.Xml; using System.IO; using System.Windows.Forms; using System.Drawing; using stdole; [GuidAttribute("34133EB7-A28F-4131-93A8-BCDB4216EDB2"), ProgId("AxessRibbon.Connect")] public class Connect : Object, Extensibility.IDTExtensibility2, IRibbonExtensibility, ICustomTaskPaneConsumer { public CustomTaskPane ctp = null; public Connect() { } public void OnConnection(object application, Extensibility.ext_ConnectMode connectMode, object addInInst, ref System.Array custom) { applicationObject = application; addInInstance = addInInst; } public void OnDisconnection(Extensibility.ext_DisconnectMode disconnectMode, ref System.Array custom) { } public void OnAddInsUpdate(ref System.Array custom) { } public void OnStartupComplete(ref System.Array custom) { } public void OnBeginShutdown(ref System.Array custom) { } private object applicationObject; private object addInInstance; #region IRibbonExtensibility Members public string GetCustomUI(string RibbonID) { Stream rbStream = Assembly.GetExecutingAssembly().GetManifestResourceStream("AxessRibbon.Resources.RibbonXml.xml"); XmlDocument doc = new XmlDocument(); doc.Load(rbStream); rbStream.Close(); return doc.OuterXml; } public IPictureDisp getImage(IRibbonControl control) { Image pic = null; switch (control.Id) { case "buttonDocInfPanel": Stream imaStream = Assembly.GetExecutingAssembly() .GetManifestResourceStream("AxessRibbon.Resources.StackedDocuments.gif"); pic = Image.FromStream(imaStream); break; default: break; } return (IPictureDisp)AxHost2.GetIPictureDispFromPicture(pic); } public void toggleTaskPane(IRibbonControl control) { switch (control.Id) { case "buttonDocInfPanel": if(ctp!=null) ctp.Visible = !ctp.Visible; break; default: break; } } #endregion #region ICustomTaskPaneConsumer Members public void CTPFactoryAvailable(ICTPFactory CTPFactoryInst) { ctp = CTPFactoryInst.CreateCTP("AxessTaskPane.MyTaskPane", "Dokument Informasjonspanel", Type.Missing); ctp.Width = 300; } #endregion } public class AxHost2 : AxHost { public AxHost2() : base(null) { } public new static IPictureDisp GetIPictureDispFromPicture(Image image) { return (IPictureDisp)AxHost.GetIPictureDispFromPicture(image); } } } I see now that my task pane and add-inn project have different namespaces...does that matter In my task pane I would like to do something line AxessRibbon.Connect.Applictation to get what host application it's running in, but I can't seem to find any information on how to do this. Can anybody save me from the madness =) Tag: Visual Studio Tools for Office Office Edition required for VSTO SE Office

SavitaHK

Hi,
Which Edition of Office 2007 is required to develop custom task panes using VSTO SE
When I tried to develop the example given in MSDN ( http://msdn2.microsoft.com/en-us/library/aa722570.aspx), i got the following errors.

The type or namespace name 'Tools' does not exist in the namespace 'Microsoft.Office' (are you missing an assembly reference )
The type or namespace name 'Interop' does not exist in the namespace 'Microsoft.Office' (are you missing an assembly reference )

Am I missing any reference I had created a Shared-In project for word, but not using 2007 Add-In as it was mentioned in MSDN, bcoz, that option was not available for me.

Is it something to do with the Edition of Office I am using I have Office Ultimate Edition, installed in my system. Any help would be appreciated.

Regards,
Savita

Re: Visual Studio Tools for Office Office Edition required for VSTO SE

Helmut Obertanner

Hello Savita,

make sure you have the following installed:

.Net framework 2.0

Office 2007 PIA's

Visual Studio Tools for Office SE Runtime (vstor.exe)

Visual Studio Tools for Office SE

Hope this helps,

greets, Helmut

Re: Visual Studio Tools for Office Office Edition required for VSTO SE

SavitaHK

Hi Helmut,

Thanx for the help.

I was missing "Visual Studio Tools for Office SE", as all the links i was getting from MS was leading to "Visual Studio Tools for Office SE Runtime (vstor.exe)" and not to " Visual Studio Tools for Office SE".

Thank you once again for the valuable information

Savita