Closing Outlook - Setup Project

Visual Studio Tools for Office

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

- Previous
  - 1
    - problem using wizards with the stored procedure in VSTO Hi! I have a stored procedure for Cross-table query (like PIVOT in SQL2005). Proceure execute sql statement which returnes dataset but in this case quantity of columns is not constant. Am I right to use the following code for data binding or there are any other methods using wizards string strSql = "exec sp_CrossTab @table='ViewPrixBySeas',@onrows='EgleS.dbo.GetSeas(data)',@onrowsalias=' ',@oncols='seas',@sumcol='summ'"; Microsoft.Office.Tools.Excel. ListObject myListObject = this .Controls.AddListObject( this .Range[ "A1" , missing], "myListObject" ); DataSet dsTable = new DataSet (); dsTrims = SomeThing .ExecuteDataSet(System.Data. CommandType .Text, strWhere); (My DataAccess Layer) this .bindingdataSource1.DataSource = dsTrims; myListObject.SetDataBinding(bindingdataSource1); Thanx. Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
  - 2
    - Outlook Add-In - No permission to execute assembly Private Sub _cbb_Click1(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean) _ Handles _cbb.Click Dim form As New frmMyCExport() form.Show() End Sub I created an Outlook Add-In which adds a toolbar with one button in an Outlook Inspector. So far so good. On this line (Dim form As New frmMyCExport()) following exception is trown : "Could not load file or assembly 'Datalogic, version....'. Failed to grant permission to execute. frmMyCExport makes uses of that assembly. How do I grant permission to that assembly I use: -Windows XP SP2 -Outlook 2003 -.Net-Framework 2.0 -VSTO Runtime -Outlook PIA Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
  - 3
    - New Deployment Article for VSTO2005 SE Hi Bill, Regarding the Vista SDK. Setup.exe checks for and installs .NET, VSTO runtime, VSTO language pack and the Office Primary Interop Assemblies. The checks for these packages are stored in the bootstrapper packages (product.xml, package.xml). In most cases the bootstrapper package does a registry or product code check. But in some cases like the PIAs we need to run code to detect if Office is present (this is ComponentCheck.cpp). This code must be written in C++ as it is not guanteed that .NET 2.0 is present when the user runs setup. VSTS, VS Pro have a C++ compiler but the original VSTO SKU did not. However, the Platform SDK does have a C++ compiler. Each version of the Platform SDK after the latest operating system. For compiling this code on XP SP2 you can use the Vista SDK. Hope that helps. Thanks and regards, Darryn Lavery [MSFT] Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
  - 4
    - When will the VSTO support create managed code solutions for word2007? I have a workflow project required to open the word2007 document and approve / reject within the word2007 document. So, when will the vsto support create managed code solutions for word2007 Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
- Next
  - 1
    - VSTO over VBA > One of the main issues is separating the code from the "view" (the worksheet). This makes it easier to update the code; you could have the code in a network location and the files on the local machine, for example You can do the same thing with Excel VBA, by putting the VBA code in an XLA. Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
  - 2
    - 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 Closing Outlook - Setup Project Office
  - 3
    - 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 Closing Outlook - Setup Project Office
  - 4
    - Retrieve images from word document Can images be retrieved from word document using VSTO 2005 - Thanks Nisha Tag: Visual Studio Tools for Office Closing Outlook - Setup Project Office
  - 5
    - 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 Closing Outlook - Setup Project Office
  - 6
    - 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 Closing Outlook - Setup Project Office
  - 7
    - 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 Closing Outlook - Setup Project Office
  - 8
    - 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 Closing Outlook - Setup Project Office
  - 9
    - 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 Closing Outlook - Setup Project Office
  - 10
    - 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 Closing Outlook - Setup Project Office
  - 11
    - 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 Closing Outlook - Setup Project Office
  - 12
    - 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 Closing Outlook - Setup Project Office
  - 13
    - 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 Closing Outlook - Setup Project Office
  - 14
    - 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 Closing Outlook - Setup Project Office
  - 15
    - 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 Closing Outlook - Setup Project Office
  - 16
    - 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 Closing Outlook - Setup Project Office

supersonic1976

Hi,

I am using Visual Studio Setup Project to deploy my Outlook Add-in. Any ideas on how to prompt the user to close outlook before the installation starts

Thanks,

Top

Re: Visual Studio Tools for Office Closing Outlook - Setup Project

X4U

Idea:

create a small exe file that checks for a running outlook process - and if so return a value other then 0.

Call this exe as custom action or as a prerequisite package from your MSI file.

Hope this helps,

greets, Helmut

Top