VSTO 2005 SE

Visual Studio Tools for Office

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

- Previous
  - 1
    - Make excel workbook readonly Thanks Ji, That certainly is a solution and I kinda figured that out while I was playing with my code. Instead of looping thru all the sheets, since I had only three sheets and was working on them at different points and modules, I password protected each of them seperately and it seems to work. I tried password protecting the whole workbook but that didn't work. Do you know why Thanks so much... bullpit Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 2
    - Problem with Installer Hi ji, Thank you very much for ur reply. I followed that links also which u have mentioned. Actually My setup was giving the following errors. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1985355&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1075209&SiteID=1 Then I just installed both VSTO, PIA manually by using indivdual setup. Then I tried my setup file. Then it just copies the files but does nothing. Can you please guide me or give me one set up which is already prepared with that I can check my mistake. Thanks in Advance Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 3
    - Publishing VSTO 2005 SE addin to a network location Rakesh, I've achieved what you describe but it was tricky First thing I recall is that if you publish to a network location there is an issue that if the network is unavailable when you load your application/addin, your addion is disabled. This is incredibly frustrating. What this means is that the files are not actually copied to your local machine and are run directly off the network which is not ideal for isntances where you want to work offline. Here is what I did. 1. I created a setup project as normal. (This is how you take care of registry, security policy and inital setup of manifest and files) 2. I then created my own updater class that I call from the addin_startup which checks the local manifest file against the manifest file in the publish location (compare the versions). 3. If the version is newer, I use xDirectory ( http://www.codeproject.com/cs/files/xdirectorycopy.asp ) to copy the contents of the publish directory (based upon the version of course) into the local machine directory. 4. I wrote a small application that is launched by my addin which passes details such as the process id and file that is open 5. This app then stops the running process and restarts it with the file that was open Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 4
    - Converting Interoped Code to Managed Code Word version is 2007. VS is 2005. I'm using VB code. Not C#. In my project References I have; Microsoft.Office.Tools.Common Microsoft.Office.Tools.Common2007 Microsoft.Office.Tools.Word Microsoft.VisualStudio.Tools.Applications.Runtime And when I hover over the Range object I get an Intellisense message that Word.Range is not defined and I should change it to Word.XMLNode. I'm okay with changing all of those IF the new XMLNode will function the same as the Range object. You said the Range object is still in there. What reference do I need to add in order to access it Thanks. In the meantime, I've downloaded and installed the Office 2007 Primary Interop Assemblies redistributable package and attempted to reference Microsoft.Office.Interop.Word.dll in my program. Nowhere is it to be found. I searched the entire C drive and still don't find it. How do I reference something that is supposed to be installed when I can't find it anywhere on the machine Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 5
    - VSTO 2005 SE Word 2003 addin won't load I know that the correct runtime is installed because I downloaded and installed it myself. When started with VSTO_SUPPRESSDISPLAYALERTS=0, Word simply reports that it can't load the addin. The message goes on to say that this could be because Word can't find the file or because of security problems. If I bring up the System Info. dialog box and look at installed COM addins for Word, my addin is listed but marked as not installed, yet it shows up on the add/remove items list in control panel. This suggestion gave me another piece of the puzzle, but I must still be missing something. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 6
    - Create MergeField from string Hi Toxter, As far as I know, we cannot capture the drop-event via VSTO, even in any technology using Word Object Model. So, when you drop anything on surface of Word, no matter it is text, picture or other objects, Word performs in its own way. Your objective cannot be achieved through VSTO. I am not very sure if Windows API can be competent for your job, but that is complicated and off topic in the VSTO forum. Thanks Ji Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 7
    - Office add-ins not running on clients Shouldn't the installer solve this And if not how do I make the installer solve it. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 8
    - Customize Outlook View--use Custom Task/Form, or what? Hi Helmut, I am facing a similar situation. Can you please elaborate upon your answer Especially the " You can also use a second pst file for your folders - or public folders on exchange to separate the folders from normal folders " part. As I would like my Document Store Folder Group to be independent of any other ( i.e. start from the root itself ). Thank You in advance, any help would be appreciated. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 9
    - add-in not working through setup project Thanks Jeff. Thanks for your reply. I had created my setup project using these two below link http://msdn2.microsoft.com/en-us/library/aa537173(office.11).aspx and part two is at http://msdn2.microsoft.com/en-us/library/aa537179(office.11).aspx . Still I am facing same problem. I am using VSTO 2005 SE. please help me. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 10
    - MS Word COM object problem Hi Utku, Thanks for your sharing the solution you find. Maybe members here will benefit from it in future! Thanks Ji Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 11
    - Shortcut Key for excel addin Hi Ji, Thanks for your reply and I have gone through the post already and I could not understand it fully as I am very new to .net environment. I have created an excel addin using VSTO SE and below given is a small bit of coding which I have done. ribbon1.xml < customUI xmlns = " http://schemas.microsoft.com/office/2006/01/customui " > < ribbon > < tabs > < tab id = " CustomTab " label = " My Menu " visible = " true " > < group id = " MyGroup " label = " My Group " > < button id = " BlueUL " label = " Blue UL " size = " normal " onAction = " MyModule " /> </ group > </ tab > </ tabs > </ ribbon > </ customUI > ribbon1.vb - ribbon callback Public Sub MyModule(ByVal control As Office.IRibbonControl) Dim ThisWkSht As New Excel.Worksheet Dim rng As Excel.Range ThisWkSht = Globals.ThisAddIn.Application.ActiveSheet rng = Globals.ThisAddIn.Application.Selection Select Case control.Id Case "BlueUL" With rng.Borders(Excel.XlBordersIndex.xlEdgeBottom) .LineStyle = Excel.XlLineStyle.xlContinuous .Weight = Excel.XlBorderWeight.xlThin .ColorIndex = 7 End With End Select End Sub Now my requirement is to assign "Ctrl + Alt + B" to the button. If you could show a sample vba procedure or some clear walk through on how to assign the shortcut key that would be great. Since I got struck with this thing for so long and the search also doesn't yield good results. Thanks in advance, Mohan Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 12
    - Change Outlook email address "to" in BeforeCheckNames() A better solution would be to save the item and then use the Recipients collection to perform the necessary modifications. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 13
    - Looping Through Open Word Documents I am working with Orcas and VSTO Beta 1. I created a new Word document project called TestWord that contains a custom ribbon. If a user has multiple Word documents open at any given time, how can I loop through them and determine which ones, if any, are my custom type containing the ribbon Thanks. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 14
    - Performance/Display issues with Windows Forms Thanks for your response. I don't understand why I would need to give my AddIn a parent WindowHandle - I have not seen this done in any VSTO code samples or solutions... is this something I should be doing in all my VSTO add-in forms The other part of this that I'm unclear on, is that if all the forms work pretty well for me and only hang for this one user, what is causing the Window handle to fail for this user Thanks again. kewpcg Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 15
    - PowerPoint 2007 Close Event ??? Hi, I am working on a project which requires me to create an Add-in to work with PowerPoint 2007 . Now here we dont have any event as BeforeClose in PowerPoint like in Word. I want to close PowerPoint on conditional bases from the application. I am using VS 2005, .Net 3.0, Office 2007. Can any one please show me any solution for the same.. Thanks in Advance... Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 16
    - Outlook Explorer Close event Thanks for response, Greate samples http://www.x4u.de/Outlook/Codesnippets/tabid/61/Default.aspx this is more or less how i implemented the work with explorers. >this is maybe because you keep a reference to an explorer object or an inspector object and then it will never close. What do you mean by sayin "then it will never close" Also i checked and even when i start Outlook ( with one explorer ) and my AddIn is loaded, after short period of time when i see in my log file that AddIn loaded and everythin registered, i close the outlook , and close event not fired. (I didn't open any inspector). I don't know what i doing wrong. TNX Tag: Visual Studio Tools for Office VSTO 2005 SE Office
- Next
  - 1
    - Giving Cell Reference for String Thanks Dennis. Let me check. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 2
    - SerializationException: Type is not resolved for member ... Hi, I'm currently at loss with this current problem. This is the scenario: I have several c# libraries (all strongly named) in my solution. This solution processes data and serialised the result into a MS SQL Server database. From my VSTO project (using VB.NET) I tried to access the database and deserialise the result back into my object. Everything works until the moment of deserialisation where I get the SerializationException: Type is not resolved for member ... I have a test project that accesses the database and deserialise my object and it is working perfectly fine, so I'm certain that the serialisation/deserialisation code is working, but just not within VSTO framework. Any ideas Cheers, Victor Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 3
    - Outlook.AppointmentItem.Conflicts - Problem Hi Sue and thanks for your reply. I read about the Find method and find it helpful, but: I'm trying to catch conflicts between appointments before the user make any change. What I'm doing is: In the BeforeItemMove event I save the time of the appointment before the change and in the ItemChange event I want to check if there any other appointment that occurs in this period of time. I wrote this method like that: private void Items_ItemChange( object item) { object objAppointmentItem = null ; try { if (flagItemChange == true ) //flagItemChange is a flag indicate that this event was raised after the BeforeItemMove event { Outlook. AppointmentItem ap = (Outlook. AppointmentItem )item; if (globalAppointmentID != string .Empty) //globalAppointmentID is a variable that keep the GlobalAppointmentID that initialize in the BeforeItemMove event { if (globalAppointmentID.Equals(ap.GlobalAppointmentID)) { string filter = "(('" + ap.Start.ToShortDateString() + " " + ap.Start.ToShortTimeString() + "'>[Start] And '" + ap.Start.ToShortDateString() + " " + ap.Start.ToShortTimeString() + "'<[End]) Or ('" + ap.End.ToShortDateString() + " " + ap.End.ToShortTimeString() + "'>[Start] And '" + ap.End.ToShortDateString() + " " + ap.End.ToShortTimeString() + "'<[End]) Or ('" + ap.Start.ToShortDateString() + " " + ap.Start.ToShortTimeString() + "'=[Start] And '" + ap.End.ToShortDateString() + " " + ap.End.ToShortTimeString() + "'=[End])) And ('" + ap.GlobalAppointmentID + "' <> [GlobalAppointmentID]) " ; objAppointmentItem = (Outlook. AppointmentItem )_sstFolder.Items.Find(filter); if ((objAppointmentItem != null ) && (((Outlook. AppointmentItem )objAppointmentItem).GlobalAppointmentID!=ap.GlobalAppointmentID)) { ap.Start = start; ap.End = end; ap.Save(); } } globalAppointmentID = string .Empty; } } } catch ( Exception ex) { string message = ex.Message; } finally { if (flagItemChange == true ) { flagItemChange = false ; } } } The problems I have: 1. Error: Condition is not valid . 2. When I replace the " ' " + ap.GlobalAppointmentID + " ' <> [GlobalAppointmentID]) to " ' " + ap.Subject + " ' <> [ Subject ]) the error is not raised but I get no item return even though I'm sure there is another appointment that should be return for the filter I wrote. any recommendation Please help, Iram Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 4
    - Addin fails to load a DLL which had its version updated. For your information: after rebuild your solution, you can use Publish Wizard to update the deployed assembly, more information you can get from this link: http://msdn2.microsoft.com/en-us/library/1h4c4ebb(VS.80).aspx Thanks Ji Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 5
    - Reading Excel From C# I would guess: open Excel from your program, and have Excel read the data. Search for Visual Studio Tools for Office (VSTO) for the details. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 6
    - Outlook Addin (VSTO) not starting when "outlook.exe" is running with no UI Hi, it seems that this issue has been the topic of many threads (e.g. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=576370&SiteID=1 ). However, I couldn't find any hint on how to solve this problem. How to reproduce: 1. Put a "MessageBox.Show()" or a "File.WriteAllText()" in the startup event handler method. 2. Run any application that starts Outlook in the background. The message or the file won't show up. However, the addin's LoadBehavior is set to two. 3. Fire up Outlook (UI) and check the addin state (Tools > Options > Other ...). It's not loaded due to some error. 4. Close Outlook (UI) and close the application that initially started Outlook in the background. The process "outlook.exe" won't shut down and has to be killed manually. Conclusion: The addin loader seems to cause the error when Outlook is launched with no UI because the addin code never seems to get called. Moreover, it seems to hold some resources that prevents "outlook.exe" from being terminated. Question: Could the conclusion be correct If not, is there any reasonable explanation for this behavior Is there a workaround or a fix for it Please let me know! Current Setup: Windows XP SP2 Outlook 2003 VSTO 2005 SE Many thanks! Florian Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 7
    - Can't get most basic VSTO 2005 SE Outlook Add-In to load Hi Pete, You might also want to refer to the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=818608&SiteID=1 . I've provided a comprehensive set of things to look for when you encounter this problem. The application in that post is Excel, but the principles are going to be the same. I think (but can't remember for sure) that the error message you are getting is generic. If so, you can set VSTO_SUPPRESSDISPLAYALERTS=0 in your environment prior to launching Outlook and you should get the real exception. If I had to guess I would think CAS is still the problem. Remember that the customization must be trusted by all four policies and that AppDomain policy will not grant full trust based solely on All Code or Zone groups. So you will need to explicitly trust the customization by some other means--such as trusting a specific location or a strong name. Sincerely, Geoff Darst Microsoft VSTO Team Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 8
    - Working With the Outlook.NK2 file Ingressor ( http://www.ingressor.com ) sells a utility for $40 that lets you view and edit the .nk2 file. I just purchased it for the short-term, but was thinking that if they could get to the file programmatically, then we would be able to as well by using VSTO or some other method. I don't want to delete the .nk2 file. I just want to be able to look at the E-mail addresses in there to quickly identify the people our users have corresponded with recently so they could be notified of our new E-mail addresses. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 9
    - Excel shapes - editing / creating mixed format Hi Jan, Excel is not good with shapes (which is also the case with me ). I assume that You work with a workbook level solution in Orca. Please try the following: Open the workbook in Excel 2007. Add a native worksheet to the workbook. Format and "configure a range in the added worksheet. Copy the range. Swith to the worksheet that will be showing it. Select the command Paste | As Picture... | Past Link Picture Hide the added worksheet. Save the workbook. When You retrieve projectnumber etc from the users You write the information to the range in the hidden worksheet. It will be automatically updated in the visible targeting sheet. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 10
    - using VSTO w/ ASP.Net 2.0 Hi Cindy, Thanks for the reply. You are saying there is no Action Pane Control in VSTO2005 SE and need full version of VSTO2005 and with Action Pane Control I could accomplished what I described. Right or need custom task pane to do this which is available with Office 2007 So, using Office 2007 I need VSTO2005 for Office 2007 too How about using xml to do this Loading data to xml and let word read the xml and display it. I found some links which is not clear how this can be done. http://msdn2.microsoft.com/en-us/library/aa212883(office.11).aspx http://msdn2.microsoft.com/en-us/library/aa223589(office.11).aspx http://msdn2.microsoft.com/en-us/library/aa203674(office.11).aspx Dennis Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 11
    - Collect information using the EntryId ? Ok. Thank you for your answer. But in fact, I find an other solution. Just pass in parameter to my form the object like this Code Snippet Outlook.AppointmentItem apptItem = (selObject as Outlook.AppointmentItem); Appointment frmAppointment = new Appointment(apptItem); But, I had an other question who has different to this problem. Do you know how to convert the attachment in a byte[] because next, I would like to save its into a database. Thank you Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 12
    - Adding pages to document based on the same template I'm having the same issue here... I want to have a word document with multiple pages from a single page template. Cindy: Is it possible to be more specific I tried to use the InsertFile method w_doc = w_app.Documents.Add(My.Settings.optPathModelesWord & "wd_template_LettreRegroupement.dot) [data insertion in w_doc here ...] w_doc.Range.InsertFile(My.Settings.optPathModelesWord & "wd_template_LettreRegroupement.dot) I guess i'm not using the InsertFile method correctly, because the first page gets replaced each time instead of adding a new page from the template Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 13
    - Drag / drop file attachment from outlook Using .NET 2.0 I'd assume there is some easy way to accept dropping a file attachment from an outlook email message onto a form I cannot seem to find any good example of this. I see some very convuluded vb 6 methods, surely there is some easy way to do this Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 14
    - Copy attachments from a email item and put in a task item in outlook. Hi, I'm doing a feature in outlook addin, when I open a email item, I am able to create a task item based on the email item, my code now is able to copy all the data in the mail item and put it into the task item, the only problem I encounter is that I am not able to copy the attachments in the email item into the task item. How am I able to do that Below is the code I already wrote: Outlook. Application outlookApp = new Outlook. Application (); object item = outlookApp.ActiveExplorer().Selection[1]; Outlook. MailItem mail = (Outlook. MailItem )item; //CreateTask Outlook. MAPIFolder tasksFolder = outlookApp.GetNamespace( "MAPI" ).GetDefaultFolder(Microsoft.Office.Interop.Outlook. OlDefaultFolders .olFolderTasks); Outlook. TaskItem taskItem = (Outlook. TaskItem )tasksFolder.Items.Add(Outlook. OlItemType .olTaskItem); taskItem.Subject = mail.Subject; taskItem.Body = mail.Body; taskItem.Save(); Thanks. Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 15
    - VSTO 2005 SE Outlook Requirements on End Users Computers Hello Gary, to run an VSTO Outlook AddIn on the target machine you need the following prerequisites installed on the target machine: .Net Framework 2.0 Outlook 2003 Outlook / Office 2003 Primary Interop Assemblies (PIA's) VSTO Runtime Executable (VSTOR.EXE) Also 1 Problem maybe on the target machine are the referenced Dll's If you have OfficeXP on the Machine and only Outlook 2003 installed I'm not sure wich Version of the Office.Core dll is installed. Maybe check this. So, eventually your only option is to setup a development machin that fit's that scenario (OfficeXP & Outlook2003) and develop on that base. Hope this helps, Greets Helmut [http://www.x4u.de] PC-in-a-Keg [http://www.x4u.de/Default.aspx tabid=266] Tag: Visual Studio Tools for Office VSTO 2005 SE Office
  - 16
    - outlook button not opening anything I will try, i know on the other machine when I hit the run button it runs but I cannot debug,etc Tag: Visual Studio Tools for Office VSTO 2005 SE Office

Danish Tehseen

I installed

MS Office 2007 including PIA 2007
Visual Studio 2005
VSTO 2005 SE

on my computer. When i create Outlook Addin project in Visual Studio 2005 i get the following message.

"Microsoft Office Outlook 2003 SP1 or newer is not installed on this computer. You must install a version of Microsoft Office Outlook 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System projects."

Would i still have to install MS Office 2003 in order to start my outlook 2007 add-in development

Thanks & Regards

Danish Tehseen

Re: Visual Studio Tools for Office VSTO 2005 SE

Ji Zhou �C MSFT

Hi Danish,

No, you do not need to install Outlook 2003. The error message tells that you are trying to create an Outlook 2003 Add In which is not the right project type. You should create an Outlook 2007 Add In.

After VSTO SE installed. There should be an Office Node in New Project Dialog. In Office Node, there should be two sub nodes named 2003 Add-ins and 2007 Add-ins. Click 2007 Add-ins, and then in the right panel, choose Outlook Add-in as your project template.

Thanks

Ji

Re: Visual Studio Tools for Office VSTO 2005 SE

Danish Tehseen

Thanks Ji

The problem was i had VSTO 2005 SE Runtime installed on my pc (not VSTO 2005 SE) due to which 2007 Add-ins were not showing in the Visual Studio 2005.