Not Able to debug VSTO word Application

Visual Studio Tools for Office

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

- 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 Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application Office
  - 3
    - New Deployment Article for VSTO2005 SE Darryn, Wow, even when you don't have time to reply in this forum, it looks as though you have time to get your article updated. That was fast! Thanks. Is there any chance that other users of your article will be working on WinXPSP2 If so, do you still want them to download the WinVista SDK Will the WinVista SDK components all run on WinXPSP2 You're probably wondering why I would try to develop software on a WinXPSP2 machine at this point As it happens, it is the only machine I have that has Office 2003 on it, and as you know, I can't install VSTO2005 on a machine that lacks Office 2003. Thanks for any clarity you can provide. I'll keep checking the article to see if it changes from day to day. Also, if you happen to have time to drop in and reply, that would be cool, too. Thanks again. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application Office
  - 6
    - VSTO over VBA Hi, Since Helmut & Cindy have give You the list of advantages I thought I would view it from a different angel, i e disadvantages: Andrew Whitechapel has recently published a list of "no no" when it comes to VSTO developing which are important to take part of: Can you build one add-in for multiple versions of Office Why is VS development not supported with multiple versions of Office Deployment: If You got a 100 % controled enviroment and it exist a good knowledge of creating robust MSI packages within the corporate then it will not be a problem that cannot be solved. At present there is no easy way to deploy VSTO solutions for Vista. The security aspect needs to be evaluated before any decision is taken. It's subject to what the needs are to read/write with the present VBA solutions. Performance: Compared with VBA the performance with VSTO solutions is at best slow. VSTO needs to communicate via layers (Interop & VSTO) which significant has a negative impact on performance. Requirements: The following blogpost indicates what is required to develop & run VSTO solutions: Requirements VSTO Solutions I don't say "No" but in my experience the needs needs to be evaluated against what the VSTO technology actually offer. VSTO itself is an interesting technology but not necessarily has it reached the production stage. The next coming version looks great in many ways but will only targeting Office 2007 and later. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 7
    - How to get the first line in a word document Since Word is focussed on dynamically laying out the document, there is no "Line" object. There's nothing to delineate a line, whereas for a paragraph the user has pressed Enter. For this reason, you can only use a "snapshot". Things of this nature must be done using the Selection object. So (in VB-speak): wdApp.Selection.HomeKey Unit:=wdStory, Extend:=False wdApp.Selection.MoveEnd Unit:=wdLine, Count:=1 wdApp.Selection.MoveEnd Unit:=wdCharacter, Count:=-1 newFileName = wdApp.Selection.Text Of course, you have to hope the use doesn't try to click or type while the above lines are running. And using them in a document that's not visible (.Visible=false) could result in incorrect results. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 8
    - XML Tags in VSTO documents disappear << The subsidiary has not yet the VSTO code rolled out, so when the document is opened there it's just a normal Word document. The subsidiary fills out the fields, mails the document back to us, and once the document is opened here, all the XML tags are missing ! All the text in the document is "as-should-be", but the surrounding tags are gone, and hence the VSTO code have a very hard time working with the document.>> pnp wrote: It should be professional - so they claim... :-) OK, in that case the next thing I'd check is what file format they're saving to. Possibly they've set the default (Tools/Options/Save) to something older file format that doesn't support XML tags. If that's not it, the next thing would be to "look over their shoulders" as they work. Is it possible that they're selecting the XML tags and deleting them without realizing it Is the related XML schema installed on these machines so that they can view the XML tags in the document as they work (display the XML structure task pane) Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application Office
  - 11
    - Best practices for server-side generation of spreadsheets My needs are similar to yours. i.e. 1. I want to deliver reports as excel files and 2. I dont want any changes on the client Excel app (no plug-ins, automation) I have tried out two options, both using SQL 2005: A. I used SSRS and a Data Driven subscription to create multiple Excel files. This worked ok when all I had to send out was Data (not charts etc). Only porb was performance and bloated file sizes. B. I used SSIS, and a sample excel with some formulae in it. I just looped through a list of subscriptions, and for each subscription, I copied the sampleexcel as the target file, and made the target file my Excel Destination, and wrote the report to that excel. This is much faster, though it needs more development work. I havent tried out stuff like charting, which, I suspect, will need Automation. I am now thinking of building a dotnet DLL that SSIS can call, to do stuff inside the Excel, like generate charts etc. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application 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 Not Able to debug VSTO word Application Office
  - 13
    - Working With the Outlook.NK2 file Ingressor did what you'd have to do to access the data programmatically: They hacked the file format. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 14
    - Outlook 2007 and Word 2007 AddIns I'm not sure what to suggest. It should work. What is your Addin trying to do Is there a Ribbon button that does not appear as expected Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
- Next
  - 1
    - 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 Not Able to debug VSTO word Application Office
  - 2
    - 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 Not Able to debug VSTO word Application Office
  - 3
    - Bugs on feedback Hi, I'm sorry to see we haven't been responsive on your bugs. Typically, the bugs submitted by customers like yourself through connect will get ported to our databases the same day. From there (assuming there is enough information in the bug to make it clear where it goes) it may take a day or two before it gets assigned out to the correct team. So realistically, you should expect a reply within a few days of submitting a bug. I apologize that you did not receive that courtesy in this case. The team has been heavily focused on developing the next version of VSTO and it looks like we haven't been paying enough attention to incoming bugs. As far as acting on bugs goes, you should have no expectations. When we are looking at bugs, we prioritize them based on their impact to the product and when we act on them is determined by where we are in the product cycle and what our next ship vehicle is. In addition, some bugs will be postponed to be fixed in future versions or ignored altogether. What we can promise you is that we will examine your bug report and by the end of the product cycle we will resolve the bug in some fashion. Whatever we do, you will be able to track the bug and its resolution through connect. Usually when we resolve a bug we will try to provide the rationale for doing so. However, if we fix a bug we typically won't provide any additional information beyond that. I should mention that submitting bugs is not a good option if you are looking for support. As you have already discovered we very likely won't even look at them in a timely fashion. In addition, when we do look at bugs, we are typically focused on fixing them in the new version. We generally don't document workarounds in our bug database unless a problem is uncovered that seems pervasive enough to warrant a knowlege base article. If you are looking for help with either of these issues, you may wish to repost them as questions in the forum. Unfortunately, I don't have any good ideas for you on either, or I'd share them. I do want to stress that we very much appreciate bugs submitted by customers. Regardless of how or when a bug gets resolved, you are helping to improve the product when you take the time to submit a bug report--so thank you! I've also ensured that the owners of these two bugs are aware that you haven't received a response, so I would expect you should get an acknowledgement shortly. Sincerely, Geoff Darst Microsoft VSTO Team Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 4
    - UDF FOR EXCEL 2003 USING VSTO 2005 SE. Hey guys if somebody can make efforts to help me plzz. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 5
    - Word 2007 Interop problem Many thanks for the help. I'll try it tonight... Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 6
    - 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 Not Able to debug VSTO word Application Office
  - 7
    - Ribbon menu and Toggle buttons Thank's for links Denis. Very useful forum! Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 8
    - 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 Not Able to debug VSTO word Application Office
  - 9
    - Outbox Frustration 1) All addresses must be resolved before a message can be sent. Some versions of Outlook will not send a message where an address has been added programmatically but not explicitly resolved. Therefore, it's always a good idea to resolve explicitly, rather than assume Outlook will do it for you. 2) Just make sure your address string is lower-case. 3) Sorry, I forgot that your code was operating only on MeetingItem objects, which don't have a SaveSentMessageFolder property. I was pointing out that property, because I've seen messages not get filed to Sent Items because that property had an invalid value. Do you have any other add-ins running If so, disable them to see if perhaps they're responsible. Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 10
    - Best practices for VSTO SE Addins Thanks for your reply but the above code didnt work. If i use you code, it laucnhes Outlook itself with no addin. Did you actually run the above code There is no Outlook.Folder property BTW. Can you help furthur Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 11
    - 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 Not Able to debug VSTO word Application Office
  - 12
    - VSTO - Outlook AddIn and ContactItem Hello Jan, I had no problems with WaitForPendingFinalizers. The key thing is that you have to call the GC's immediatly after you set this 2 variables to null. This will release the COM Reference from your Wrapper Class to the underlaying Outlook-COM Objects. Whenever this occures in the class. If you don't call a GC here - the .Net Appdomain will keep a ref to the COM Objects - some kind of internal memory management and caching and when you open the Item a second time - you will get the wrapped .Net object from cache. And this is while you see your modified data. Hope this helps, greets, Helmut Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 13
    - VSTO se sorting problem Hi John, I write some C# codes which implement your object. And I think you can convert it to VB version easily Code Snippet private void Form1_Load( object sender, EventArgs e) { const int color1Index = 3; const int color2Index = 5; const int color3Index = 10; int sumColor1 = 0, countColor1 = 0, countColor1GTZ = 0; int sumColor2 = 0, countColor2 = 0, countColor2GTZ = 0; int sumColor3 = 0, countColor3 = 0, countColor3GTZ = 0; object missing = Type .Missing; myApp = new Microsoft.Office.Interop.Excel. Application (); myApp.Visible = true ; Excel. Workbook myWB = myApp.Workbooks.Open( @"C:\test.xlsx" , missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); Excel. Worksheet myWS = myApp.ActiveSheet as Excel. Worksheet ; Excel. Range myRange = null ; for ( int i = 1; i <= 10; i++) { myRange = myApp.Cells[i, 1] as Excel. Range ; if ( Convert .ToInt32(myRange.Interior.ColorIndex) == color1Index) { int content = Convert .ToInt32(myRange.Text); countColor1++; sumColor1 += content; if (content > 0) { countColor1GTZ++; } } else if ( Convert .ToInt32(myRange.Interior.ColorIndex) == color2Index) { int content = Convert .ToInt32(myRange.Text); countColor2++; sumColor2 += content; if (content > 0) { countColor2GTZ++; } } else if ( Convert .ToInt32(myRange.Interior.ColorIndex) == color3Index) { int content = Convert .ToInt32(myRange.Text); countColor3++; sumColor3 += content; if (content > 0) { countColor3GTZ++; } } else { MessageBox .Show( "There are still colors which are not dealt with" ); } } MessageBox .Show(sumColor1.ToString()+ " " +countColor1.ToString() + " " + countColor1GTZ.ToString()+ "\n" + sumColor2.ToString() + " " + countColor2.ToString() + " " + countColor2GTZ.ToString() + "\n" + sumColor3.ToString() + " " + countColor3.ToString() + " " + countColor3GTZ.ToString() + "\n" ); } Hope this helps! Thanks Ji Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 14
    - Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007 Hi Do you mean by loading that I need to install VSTO 2005 SE Because I have it installed. Regards Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 15
    - Cypress Outlook 2007 addin installation problems The product code of VSTO 2005 SE runtime is the same as VSTO 2005 so that part of the paper is still applicable to the SE. There is an additional regkey that enables you to distinguish between VSTO 2005 and VSTO 2005 SE runtime that you can check for: HKLM\Software\Microsoft\VSTO Runtime setup\v2.0.50727 Update=1 The VSTO runtime deployment paper is in the process of being updated with this and other additional suggestions for VSTO 2005 SE runtime deployment - you should be able to see this hopefully by the end of the year or so. (Note that the SE runtime deployment story is essentially the same as the VSTO 2005 runtime - we will just be talking about some new suggestions regarding pre-reqs and install checks, since there are so many new MSOffice apps that the runtime can now target) Hope this helps Best regards Tag: Visual Studio Tools for Office Not Able to debug VSTO word Application Office
  - 16
    - 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 Not Able to debug VSTO word Application Office

Thekkepad

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

Top