Installed Office version.

Visual Studio Tools for Office

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

- Previous
  - 1
    - How to get the first line in a word document Hello, I have a word addin the prompt the user to save the current document. I want the document name to be the first line in the document. Thanks Tag: Visual Studio Tools for Office Installed Office version. Office
  - 2
    - XML Tags in VSTO documents disappear Hi Anders OK, I made a quick test and they should be able to see the tags (assuming they have Office Pro). But it's possible the tags aren't displayed - that's a setting that may need to be activated (in the XML Structure task pane). The only other trouble-shooting step that occurs to me is to try setting up a document with XML tags in Word (not as a VSTO project) in a similar manner. See if the same problem occurs. And set up a machine for testing without the VSTO solution, open the VSTO document and see what happens. Tag: Visual Studio Tools for Office Installed Office version. Office
  - 3
    - Retrieve images from word document Can images be retrieved from word document using VSTO 2005 - Thanks Nisha Tag: Visual Studio Tools for Office Installed Office version. Office
  - 4
    - VSTO for Excel Hi All, I would really appreciate any assitance that could be given in this matter. So far, I have not been able to find the answers I wanted to these questions. OBJECTIVE: I am building an application using VSTO 2005, Oracle, and Excell 2003 that will get data from Oracle and create (grouped and sorted) tables and charts to go with it. QUESTION: Therefore, I am wondering if it is possible for the Excel Chart object to be created and destoryed and recreated dynamically in the same chart space. I am assuming that this is possible since one can just change the chart type in the chart after the chart has been created. Is this assumption correct (Also there needs to be a datasheet with the datatable, on a seperate sheet) Also is it possible to create multiple document actions pane We are trying to create a menu where the user would click on the item and a submenu set would be displayed, by a transitioning task pane of some sort. I am, once again assuming this is possible since MS Access switchboard uses a similar method. Also in a chart (for example a pie graph of Male to Female ratio for participation in a survey), you click on a dataset (say, the Female dataset), and have a secondary chart appear with that further displays the information relative to the dataset selected. (for example you click on the female dataset, and another chart pops up that displays the ratio of the regions that the Females came from) Please help. Thank you. (I am trying to do this in VSTO / Excel due to the requirments of the assignment) Tag: Visual Studio Tools for Office Installed Office version. Office
  - 5
    - Best practices for server-side generation of spreadsheets I believe Cindy's answer explains the current situation with server-side generation of Open Office XML file formats. I will mark this reply as an answer and close this thread. Tag: Visual Studio Tools for Office Installed Office version. Office
  - 6
    - Problem linking assembly to existing Excel file We are having a problem linking an assembly produced by Visual Studio 2005 to an existing Excel 2003 spreadsheet (.XLS) file. (The assembly is correctly linked to the Excel 2003 spreadsheet created by the Visual Studio 2005 project.) With Visual Studio 2005 and Microsoft Visual Studio 2005 Tools for Office 2007 SE we have successfully built an install project that deploys a strongly named assembly ExcelWorkbookSimple.dll with ExcelWorkbookSimple.xls. This "app" just puts up a simple ActionPane. The ExcelWorkbookSimple.xls file can be copied anywhere and works -- starting the ActionPane -- as long as the installed directory containing ExcelWorkbookSimple.dll is available and has not been renamed. We have tried adding the AssemblyLocation / AssemblyName custom properties using Excel and Windows Explorer with no success. Each time we get the following message: "The current .NET security policy does not permit ExcelWorkbookSimple to run from the folder C:\The\Actual\Path\. Do not change the security policy in your computer. The .NET security policy is controlled by your administrator or the developer who wrote the custom macros. You can still edit and save the document. Contact your administrator or the author of this document for further assistance." We are not trying to reference a LAN / network location, nor are we trying to access a web location. We are trying to access a folder on the same computer. We tried _AssemblyLocation0 = C:\The\Actual\Path\ and C:\The\Actual\Path _AssemblyName0 = ExcelWorkbookSimple and _AssemblyLocation = C:\The\Actual\Path\ and C:\The\Actual\Path _AssemblyName = ExcelWorkbookSimple from both Excel and Windows Explorer. caspol -lf did not initially show ExcelWorkbookSimple.dll had full trust. caspol -rsp ExcelWorkbookSimple.dll showed the following before and after adding full trust: Microsoft (R) .NET Framework CasPol 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. Resolving permissions for level = Enterprise Resolving permissions for level = Machine Resolving permissions for level = User Grant = <PermissionSet class="System.Security.PermissionSet" version="1" Unrestricted="true"/> Success Granting full trust worked as follows: C:\The\Actual\Path>caspol -af ExcelWorkbookSimple.dll Microsoft (R) .NET Framework CasPol 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. Because all GAC assemblies always get full trust, the full trust list is no long er meaningful. You should install any assemblies that are used in security policy y in the GAC to ensure they are trusted. The operation you are performing will alter security policy. Are you sure you want to perform this operation (yes/no) yes Success caspol -lf after granting full trust showed the assembly: Microsoft (R) .NET Framework CasPol 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. Security is ON Execution checking is ON Policy change prompt is ON Level = Machine Full Trust Assemblies: ... 22. ExcelWorkbookSimple 1.0.0.0 = StrongName - 0024000004800000940000000602000000240000525341310004000001000100E7D33901080D61DBD1F68A4A9432F633B28233AB9572BA75763EAF9B59894EA45D36303BD2CB7669052E0508A2EB0C30BAE44E1A49FF43ECC978C100DB42E8A021F66A80F0B35668C8A44DFC5795349AC8C9FCC245FECDB539A964A059544CF2A9A67DE13D6C05A84DB31E36A9031772426E2DC5A1D8A6019F862F5762D176D4 name = ExcelWorkbookSimple version = 1.0.0.0 Success Even after granting full trust we still get the same message. Thanks Tag: Visual Studio Tools for Office Installed Office version. Office
  - 7
    - Working With the Outlook.NK2 file Follow-up: You can download a FREE copy of NK2View from http://www.nirsoft.net/utils/outlook_nk2_autocomplete.html . It allows you to view and export the entries in the file, but not modify them. Keep in mind that .nk2 files are hidden system files and you will need to set Windows Explorer to display these types of files. It should be located in c:\documents and settings\%username%\Application Data\Microsoft\Outlook\Outlook.nk2. Tag: Visual Studio Tools for Office Installed Office version. Office
  - 8
    - Outlook 2007 and Word 2007 AddIns Hi everybody, This is my first time posting a question in this forum. Lets get straight to the problem. Situation:- I've created an addin for Word 2007 using VSTO2005 SE. My task now is to re-create the same addin (same function, same look) in Outlook 2007. Addin contains function like setting a specific language in document, calling an external exe file and so on. I've configured Outlook to use Word as its email editor. So my question is, can I just use the existing Word addin or do I need to create a separate addin for Outlook Any help is much appreciated. Thank you, Westman (Software Engineer-TNT) Tag: Visual Studio Tools for Office Installed Office version. Office
  - 9
    - Not Able to debug VSTO word Application Hi, I Have installed VSTO 2005 SE last week and started experimenting in that. Now I am not able to debug the word ADDIN projects. Even if i add any code in _StartUp Method It is not executing... Any clue Suresh Tag: Visual Studio Tools for Office Installed Office version. Office
  - 10
    - Programmatic access to Visual Basic Project is not trusted Hi all, I was trying to write a script for Word 2003 sp 3 on Windows XP sp2 in python, but when I run he script I get the error: COMError: (-2146822220, None, (u'Programmatic access to Visual Basic Project is not trusted.', u'Microsoft Word', u'C:\\Program Files\\Microsoft Office\\OFFICE1 1\\1033\\wdmain11.chm', 25548, None)) I looked in the knowlegde base article dealing with this problem and there was said that I just have to enable "Trust access to Visual Basic Project", when I looked in the settings this checkbox was already ticked, but I still get the error above. Any help much appreciated! Thanks a million, Radu. Tag: Visual Studio Tools for Office Installed Office version. Office
  - 11
    - Managed code extensions not working for word template I have created a word template that presents a UI in ActionsPanelControl on start up that is used to populate bookmarks. I see the UI when I run the project in Debug or release mode or by opening the template from the Debug or release folder. But when I copy the .dll and .dot file (in same folder) to some other location I don’t see the UI I don’t even get the error message that states that the current .NET security policy does not permit the customization to run. I am wondering what is going here Thanks Tag: Visual Studio Tools for Office Installed Office version. Office
  - 12
    - Bugs on feedback I've recieved a notification on the port issue from the MSF Feedback staff that the bug was resolved as By Design and Closed accordingly. So we know now that we can't deploy a VSTO assembly to a web site with non-default port number and this is by design!! But the question is: is it going to be fixed in the next VSTO version or it's by design due to a problem in a component out of the VSTO scope Like a problem in the CLR itself for example!! (the part responsible for code-access security checking). We realy have no idea about that as I haven't seen any comment on the bug from MSF.. So we have to live with it till futher notifications.. and remeber not to publish VSTO assemblies to other than the default web site (port 80). Tag: Visual Studio Tools for Office Installed Office version. Office
  - 13
    - 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 Installed Office version. Office
  - 14
    - 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 Installed Office version. Office
  - 15
    - 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 Installed Office version. Office
  - 16
    - 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 Installed Office version. Office
- Next
  - 1
    - 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 Installed Office version. Office
  - 2
    - 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 Installed Office version. Office
  - 3
    - 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 Installed Office version. Office
  - 4
    - 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 Installed Office version. Office
  - 5
    - 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 Installed Office version. Office
  - 6
    - 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 Installed Office version. Office
  - 7
    - 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 Installed Office version. Office
  - 8
    - 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 Installed Office version. Office
  - 9
    - 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 Installed Office version. Office
  - 10
    - Word add-in and winform control Thank you I'll try to post on theses newsgroups Tag: Visual Studio Tools for Office Installed Office version. Office
  - 11
    - 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 Installed Office version. Office
  - 12
    - Word VSTO Issue. 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. Tag: Visual Studio Tools for Office Installed Office version. Office
  - 13
    - 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 Installed Office version. Office
  - 14
    - 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 Installed Office version. Office
  - 15
    - 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 Installed Office version. Office
  - 16
    - 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 Installed Office version. Office

Westman

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

Top

Re: Visual Studio Tools for Office Installed Office version.

Douglas H. Troy

You should be able to check

HKCU\Software\Microsoft\Office\

Under that hive, you'll see several versions there, 10.0, 11.0, 8.0, etc... I'm fairly certain that if a particular component is installed for that version of office, you'll find a folder under each of those for that component:

example
Word for Office 2003 would be under
HKCU\Software\Microsoft\Office\11.0\Word

Word for Office 2007 would be under
HKCU\Software\Microsoft\Office\12.0\Word

You also might want to have a look at the new ComponentCheck, it might contain the product IDs for the various installed versions of Office (I've yet to have the chance to dig into that one).

You can find the source for ComponentCheck attached to this MSDN article
http://msdn2.microsoft.com/en-us/library/bb332051.aspx

Top