Programmatic access to Visual Basic Project is not trusted

Visual Studio Tools for Office

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

- 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 Programmatic access to Visual Basic Project is not trusted 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 Programmatic access to Visual Basic Project is not trusted Office
  - 3
    - New Deployment Article for VSTO2005 SE Hi Siddhu, As you found out ther are two components to the instller: setup.exe checks for installs and the pre-requisites and the MSI installs the solution & sets the security policy. Unfortuneately you will need both and there is no way to produce just one file. Alternatively you could package the installer into a single zip and distribute it that way. Thanks Darryn Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted 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 Programmatic access to Visual Basic Project is not trusted Office
  - 5
    - Closing Outlook - Setup Project 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, Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 6
    - VSTO over VBA ... and another disadvantage that might be important in some apps, is that with VSTO you can't easily automate other Office apps without the risk of leaving zombie Office application processes running, for the reasons discussed here: http://support.microsoft.com/default.aspx scid=kb%3ben-us%3b317109 Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 7
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 8
    - XML Tags in VSTO documents disappear That was some of my initial doubts as well... That the error occurred by the users doing something bad without knowing it. I have made a 4 step guide, where they in between each step does ctrl+shift+x to verify if the xml tags are still there. That might spot something. I would not believe the xml schema is installed on their machines. For users in our building this is done by the VSTO code, and since they don't have the code, and no one has thought of doing it manually - i will not expect them to have the schema installed. Could this cause this That if word does not have the schema installed, then it will remove the tags Will it make them unable to view the tags, if the schema is not present /Anders Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 9
    - Retrieve images from word document Can images be retrieved from word document using VSTO 2005 - Thanks Nisha Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 10
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 11
    - Best practices for server-side generation of spreadsheets Hi, Thank you for your input. I'm afraid I don't know what SSRS is. And I have to say I find it a little bit incredible, given the ubiquity of Office, that no Microsoft or third-party component exists for this. Perhaps it is a good idea for a startup; now the file formats are open and documented and all there should be plenty of possibility for doing this. It would require basically a DOM for each document type (Word, Excel, Powerpoint,...) and logic to "render" and parse the XML... I haven't looked into this, and I suspect the license constraints prevent us from using it, but one idea is to take a trip to SourceForge and take a look at the OpenOffice source code. Internally, the application should use something like a DOM anyway, and saving and loading files obviously corresponds to parsing and rendering. With luck, there will already be a clean separation between code that interacts with the user and "pure model code" - if so, it is just what we need. I don't know what license it is under though, and in my scenario it is certainly not an option to disclose our source code, give away the application for free, or allow anyone to modify it.... Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 12
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 13
    - Working With the Outlook.NK2 file OK, thanks for the feedback. I just wanted to make sure there wasn't already something in place that could be used. Roman Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 14
    - Outlook 2007 and Word 2007 AddIns If you want your add-in's functionality to be available in the email editor, you'll need to write a separate add-in for Outlook, which uses a stub of Word, not Word.exe, for the email editor. Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 15
    - Not Able to debug VSTO word Application Hi Suresh - With Office 2003, there is the possibility that the AddinLoader.dll which replaces mscoree.dll can be blacklisted. Check to see if it's listed as disabled in Help / About / Disabled Items. If it's not there, we'll try something else. Andrew Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
- Next
  - 1
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 2
    - Bugs on feedback Thanks Geoff for your explanation, I've just received two notifications that Microsoft have received the bugs and working on them :-) I understand your bugs resolution process and appreciate your efforts getting them resolved no matter what. The only thing I was anxious about was the no feedback I��ve noticed. I agree with you and re-emphasize that all customers submitting bugs had done so because of their commitment to Microsoft as partners and to the community as contributors to the industry development. Thank you VSTO team. Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 3
    - UDF FOR EXCEL 2003 USING VSTO 2005 SE. Hi parm, With all the respect to VSTO but it simple lacks the basic to work with UDF in Excel (at least in the present version). Use the following approach by Eric Carter: Writing user defined functions for Excel in .NET: http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 4
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 5
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 6
    - Ribbon menu and Toggle buttons Thank you very much, Franck! It works! small offtopic: why you written if (_SDataAssignmnetsPressed) return true; return false; Is it some of best practice codestyle I think this looks bit better: return _SDataAssignmnetsPressed; Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 7
    - Installed Office version. Hi, Right now, I'm using the key below to detect the version of office installed. HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Application\CurVer My problem is, if the target computer have both office 2007 and office 2003 installed, how do I detect how many version of office were installed My solution is based on VSTO2005 SE and VS 2005 Pro on XP SP2. Any help is appreciated. Regards, Westman Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 8
    - Outbox Frustration Hi First suggestion like Sue says is to see if any other addins are affecting things, the next thing is to create a standard Event handler and rem all of your code and see whether the API hook is causing this issue, The last thing I would suggest and have seen before is making sure you are using the PIA's (Primary Interop Assemblies) http://www.microsoft.com/downloads/details.aspx familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad is the office 2003 download. If you have a blank method IE No code in the handler and this still fails the send of the item then Try reinstalling the PIA's and making sure you re-reference your Office COM Objects in the solution. Regards Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 9
    - Best practices for VSTO SE Addins Hi, I did use all the codes above on my environment. Why there is no Outlook.Folder property It seems that you are using Outlook2003, right OK, I will write some codes in Outlook 2003 and post later. Thanks Ji Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 10
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 11
    - VSTO - Outlook AddIn and ContactItem X4U wrote: Hello Jan, .... Greets, Helmut It's kind of fun that You answer my thread Helmut. Last week I've spent a lot of time investigating this Add-In technology (new to me). And of cource, when googling about the theme, Your name came up a lot So, since You're already in this thread Helmut, I like to pop in another more important question. The above problem I get into when developing for fun at home, but the very reason for investigating and developing Add-In is a particular bug I try to solve at job. (I'm a consultant, performing a bugfix in an Add-In written by others some time ago.) I think I've found the solution by reading Your stuff at x4u and stuff in Eric Carters blog , but I like to have Your opinion: Problem: The existing code throw an exception when trying to execute codeline like: inspectors.NewInspector += new Outlook. InspectorsEvents_NewInspectorEventHandler (OnNewInspector); Stack say: System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used. at System.Runtime.InteropServices.UCOMIConnectionPoint.Advise(Object pUnkSink, Int32& pdwCookie) at Microsoft.Office.Interop.Outlook.InspectorsEvents_EventProvider.add_NewInspector(InspectorsEvents_NewInspectorEventHandler ) at Microsoft.Office.Interop.Outlook.InspectorsClass.add_NewInspector(InspectorsEvents_NewInspectorEventHandler ) The Add-In was originaly developed as a Shared Add-In, implementing the Extensibility.IDTExtensibility2 interface. Later the Add-In was ported (rewritten) to be a VSTO Add-In for Outlook. I think that the "porting" was poor, and the code was not reviewed with "VSTO-eyes" ... if You understand My theory: The Add-In code performs call to ReleaseComObject, and in my understanding there is no need to call ReleaseComObject in a VSTO Add-In ... or even, it can be "dangerous" if doing it incorrect. So, when seeing that stack, and knowing that code perform ReleaseComObject, my solution will be to remove ReleaseComObject-calls, and let GC do the job ..... I've created the new Add-In with such fix, going to let the customer test it tomorrow What do You think Helmut Hope to hear from You .... Rgds Jan Inge Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 12
    - VSTO se sorting problem Hi Ji Gosh! Wow! Thanks I see you have gone to some trouble to write some special code in C#. I am afraid I only have the most basic idea of codes. Can I implement this directly into excel or do I have to convert it to VB If it needs to be converted you say that is easy, can I beg a bit of guidance on that one. Many thanks John Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 13
    - Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007 Yes, when you installed VSTO 2005 SE it also installed SE runtime. My next troubleshooting question is: do you have Word 2003 and Word 2007 installed on the same computer It sounds like you do if you're creating a Word 2003 template document project. We explicitly warn against side-by-side installation in the VSTO 2005 SE documentation. If that is the case, then I suggest removing Office 2007 from your development machine and then set set up another machine (or a Virtual PC, or a dual boot) for testing on Word 2007. You can use the easiest form of deployment by simply using the Publish to a shared network location. Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 14
    - Cypress Outlook 2007 addin installation problems The MSDN article is no longer available. What happened to it Thanks, Patrick Schmid Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office
  - 15
    - 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 Programmatic access to Visual Basic Project is not trusted Office
  - 16
    - COM exception when trying to add picture as inline shape in Word 2007 RTM Hi Cindy, The above code snippet which you have added perfectly works fine. In my case I am not using Marshal.GetActiveObject(...) but for I create an instance of Word.Application. Replace the first 2 lines of your code snippet by the lines shown below, ------------------------------------------------------------------------------------ Dim wdApp As Word.Application = New Word.Application wdApp.Visible = True Dim wdDoc As Word.Document = wdApp.Documents.Add(Visible:= True ) ------------------------------------------------------------------------------------ Now you will be able to reproduce the issue raised by me originally. This error occurs on that line when I STEP through the code as well in debug mode. I wont be able to use Marshal.GetObject(...) because I get a document instance via SmartDocument API(ISmartDocument.SmartDocInitialize) Cheers Babu Tag: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted Office

user11

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.

Top

Re: Visual Studio Tools for Office Programmatic access to Visual Basic Project is not trusted

Cindy Meister

I'm afraid this falls outside the scope of the VSTO forum. VSTO is a particular Visual Studio .NET technology.

Your best bet would be one of the office.developer newsgroups, as listed in the "Please Read First" message at the top of this forum. You might also try testing on a system without SP3 installed. There have been numerous reports of "odd things" with that SP...

Top