Please advise on Add-in Express

Visual Studio Tools for Office

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

- Previous
  - 1
    - VSTO for Excel http://www.codeproject.com/useritems/ExcelCSharp.asp Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 2
    - Best practices for server-side generation of spreadsheets I think you could also programatically generate the spreadsheets using SSRS as a Web Service and a Visual Studio client. I am planning to try this shortly. Please let me know if you find more on this. Thanx Kar Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 3
    - Problem linking assembly to existing Excel file Brian, Check out the following KB-article if that's relevant for the issue: Incorrect assembly link location for an Excel 2003 workbook that has a file name with DBCS characters Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 4
    - 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 Please advise on Add-in Express Office
  - 5
    - Outlook 2007 and Word 2007 AddIns Hi, Thanks for the reply. When I open Outlook and tried to compose a message, the addin did not appear. What went wrong Do I need to add/modify something in my Word addin code FYI, The addin was working and running successfully in WOrd 2007. My addin doesnt contain any function that related to Outlook, it should just appear in the email editor. Regards, Westman. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 6
    - Not Able to debug VSTO word Application It is Happening with new project i Create and I have office 2003 Installed in my system. Suresh Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 7
    - 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 Please advise on Add-in Express Office
  - 8
    - 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 Please advise on Add-in Express Office
  - 9
    - Bugs on feedback I am not using SP1, I am using Team System version 8.0.50727.42 with an update of (KB915364) to enable web projects under vs 2005. I faced this port problem since we wanted to use the default web site as the sharepoint web site and use another web site with different port number to be our VSTO project site, it is really annoying and we had to move our application to be under default web site (port 80) and exclude it from sharepoint to workarround this problem . The problem seems to me a VSTO run-time which I don't think it has to do with any VS service packs!! What do MSF people think Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 10
    - UDF FOR EXCEL 2003 USING VSTO 2005 SE. hi thanks but this could not solve my problem. when we create add-in using vsto 2005 SE we get two methods as: private void ThisAddIn_Startup(object sender, System.EventArgs e) and private void ThisAddIn_Shutdown(object sender, System.EventArgs e) so dont have method with name : ThisWorkbook_Startup. when i write below ThisApplication.Run ("CallbackReg", new MyUdf()); in ThisAddIn_Startup . this gives error. so please tell me all this in refrence to above ThisAddin_startup and _shutdown methods. please guide me in same way as a sample given in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=426211&SiteID=1 Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 11
    - Word 2007 Interop problem Hi ichi I thought I answered this a couple of days ago... The problem appears to be the situation outlined in this KB article http://support.microsoft.com/default.aspx scid=kb;en-us;313104 Using Late binding works. For example: Dim rng As Object 'Word.Range = wdDoc.Content rng = CType(wdDoc.Content, Word.Range) Try With rng.Find .ClearFormatting() .Text = "abc" .Replacement.ClearFormatting() .Replacement.Text = "123" .Execute(Replace:=Word.WdReplace.wdReplaceAll) End With Catch Dim ex As Exception MessageBox.Show(ex.Message) End Try If you need to use Selection instead of Range, then declare sel as Object, not as Selection. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 12
    - 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 Please advise on Add-in Express Office
  - 13
    - Ribbon menu and Toggle buttons Hi !! Possible work around <group id="SData" label="S Data"> <toggleButton id="SDataAssignmnets" size="large" label="Assignments" screentip="Show/hide external data Task Pane" onAction="OnSDataButton" image="Folders 32 n p.png" getPressed="GetPressed"/> <toggleButton id="SDataCustomers" size="large" label="Customers" screentip="Show/hide external data Task Pane" onAction="OnSDataButton" image="File and Folder 2 32 n p.png" /> getPressed="GetPressed"/> <toggleButton id="SDataContacts" size="large" label="Contacts" screentip="Show/hide external data Task Pane" onAction="OnSDataButton" image="Contact 32 h p.png" getPressed="GetPressed"/> group> private bool _SDataAssignmnetsPressed = false; private bool _SDataCustomersPressed = false; private bool _SDataContactsPressed = false; public bool GetPressed(Office.IRibbonControl control) { switch (control.Id) { case "SDataAssignmnets": if (_SDataAssignmnetsPressed) return true; return false; case "SDataCustomers": ... case "SDataContacts": ... } } public void OnSDataButton(Office.IRibbonControl control, bool IsPressed) { switch (control.Id) { case "SDataAssignmnets": _SDataAssignmnets = true; _SDataCustomersPressed = false; _SDataContactsPressed = false; ... case "SDataCustomers": ... case "SDataContacts": ... } this.ribbon.Invalidate(); } best regards Franck Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 14
    - 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 Please advise on Add-in Express Office
  - 15
    - Outbox Frustration I appreciate your trying to help. 1 - I may be missing something, but I thought the Resolve method just checked to see if the recipient can be resolved any valid entry in the Address Book. I'm trying to check for a specific email address. 2 - Yes, the code example I posted will always be false... sorry. I replaced the actual "other email address" from my code with a generic MyOtherEmail@Someplace.com when posting the note... so my real email address wouldn't be posted as part of the code... 3 - Your last point is really confusing me. If I create a meeting item, I can see the SaveSentMessageFolder property. But if I look at the Item passed in by the application to the Application_ItemSend event, it does identify it as a MeetingItem (using the TypeOf method), but it does not seem to have a SaveSentMessageFolder property. dw Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 16
    - Best practices for VSTO SE Addins Hi Kulvinder, I have read about your issue carefully. As you described, the Outlook Add In created by VSTO SE was not loaded when you open Outlook through an Outlook Automation. I have also reproduced the scenario and in fact the AddIn was loaded, just the toolbar is not there. Below is my explaination. Firstly, Outlook Automation does not perform like Word and Excel. There is not a Visible property of Outlook.Application Object, so you have to use such codes to let Outlook be Visible(I believe you are using the similar ones): Code Snippet private void Form1_Load( object sender, EventArgs e) { Outlook. Application myApp = new Microsoft.Office.Interop.Outlook. Application (); Outlook. NameSpace ns = myApp.GetNamespace( "MAPI" ); Outlook. Folder folder = ns.GetDefaultFolder(Microsoft.Office.Interop.Outlook. OlDefaultFolders .olFolderInbox) as Outlook. Folder ; Outlook. Explorer explorer = myApp.Explorers.Add(folder, Microsoft.Office.Interop.Outlook. OlFolderDisplayMode .olFolderDisplayNormal); explorer.Activate(); } After creating the object myApp, the Starup event in your AddIn is raised, and till now there is no explorer in your Office Automation.So if we add the toolBar in the ThisAddIn_Startup method, the toolbar which depends on at least one explorer will not appear. The solution is that add the toolBar in functions hanld the active event of every explorer. To do this ,you should register every explorer's active event when it is created. Following are my codes in VSTO SE AddIn: Code Snippet Outlook. Explorers myExplorers = null ; Office. CommandBar myCommandBar = null ; Office. CommandBarButton myCommandBarButton = null ; private void ThisAddIn_Startup( object sender, System. EventArgs e) { myExplorers = this .Application.Explorers; myExplorers.NewExplorer += new Microsoft.Office.Interop.Outlook. ExplorersEvents_NewExplorerEventHandler (Explorers_NewExplorer); if ( this .Application.Explorers.Count == 1) { AddMenuButton(); } } void myCommandBarButton_Click(Microsoft.Office.Core. CommandBarButton Ctrl, ref bool CancelDefault) { MessageBox .Show( "Test Button Clicked!" ); } void Explorers_NewExplorer(Microsoft.Office.Interop.Outlook. Explorer Explorer) { ((Outlook. ExplorerEvents_10_Event )Explorer).Activate += new Microsoft.Office.Interop.Outlook. ExplorerEvents_10_ActivateEventHandler (ThisAddIn_Activate); AddMenuButton(); } void ThisAddIn_Activate() { AddMenuButton(); } private void AddMenuButton() { try { myCommandBar = this .Application.ActiveExplorer().CommandBars[ "Menu Bar" ]; myCommandBar.Reset(); Office. CommandBarControl myCommandBarControl = myCommandBar.Controls.Add(Office. MsoControlType .msoControlPopup, 1, missing, missing, true ); myCommandBarControl.Visible = true ; myCommandBarControl.Caption = "Test" ; myCommandBarButton = ((Office. CommandBarPopup )myCommandBarControl).CommandBar.Controls.Add(Office. MsoControlType .msoControlButton, 1, "" , 1, true ) as Office. CommandBarButton ; myCommandBarButton.Caption = "test" ; myCommandBarButton.Click += new Microsoft.Office.Core. _CommandBarButtonEvents_ClickEventHandler (myCommandBarButton_Click); } catch ( Exception ex) { } } Hope this is what you want :-) Thanks Ji Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
- Next
  - 1
    - VSTO - Outlook AddIn and ContactItem X4U wrote: Hello Jan, I asume that you have used an InspectorWrapper class for this. As soon as the Inspector.Close event has fired you should do: _ContactItem = null; _Inspector = null; GC.Collect(); GC.WaitForPendingFinalizers(); This hard-release should help here. Greets, Helmut Thx for replying Helmut . Yes I have the InspectorWrapper ... used exact that classname too and also already have those two private members in the wrapper ... spooky I'll try it, but this lead to 2 new questions: 1) Isn't it "dangerous" to call GC.WaitForPendingFinalizers .. infinite loop 2) I guess that my existing OnInspectorClose event should perform your code as the very last thing Rgds Jan Inge Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 2
    - VSTO se sorting problem Hi Ji Thank you. Yes you are correct in assuming that I am trying to "to get the sum of pinks (it's 8 in your example), count of pinks:5, and count of pinks which are greater than zero:4" The background to this is a friend of mine, who is a professional Lepidopterist, has recorded data in spreadsheets he has been asked to split it into absolute and estimated. I have suggested adding extra columns and splitting the data between the columns. This he assures me may sound simple but leaves him with a massive task of rebuilding his whole data collecting system and he has colour coded things and would like to analyse data on the basis of the cell colour. I have tried a number of things including some code that sums on cell colour but it does not allow count if not zero as if counts all zeros not just pink ones. If you know of some Visual Basic code that I can embed into the spreadsheet it would solve the problem. I have historical medical data I have not reanalysed because of having to do a lot of manual sorting and this coud ease the burden and make that data-mining worthwhile. Regarding the problem of colour and color, this is seperate issue, don't trouble yourself with it as neither of us can solve that one. It is an age long battle between British English and American English. I hope this makes sense now. Many thanks for your help. John Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 3
    - Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007 The VSTO Second Edition Runtime solves many problems associated with running a Word 2003 doc project in Word 2007. Try loading the Second Edition Runtime and see if you still get the same error. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 4
    - Cypress Outlook 2007 addin installation problems It turns out that you do need to follow the steps in http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstowindowsinstallerwalkthrough.asp#officevstowindowsinstallerwalkthrough_creatinginstallerpackagestodeploysolutions to be able to deploy a Cypress Outlook addin, even to the the same machine where the addin was developed. The assembly must also be signed. I skipped the steps for adding a check for the Outlook 2007 PIA and the VSTO runtime because so far I'm only deploying to other computers that are running Office 2007 and that have Cypress installed. I'm also not sure about the ComponentID for the Cypress runtime and I'm guessing it's not the same as the one for the VSTO 2005 runtime. I also haven't seen any redistributable runtime for Cypress so far, I'm not sure one is available yet. How would I go about finding the ComponentID of the Cypress runtime so I can add a check for that into the installation prerequisites Is the ComponentID going to be the same for the release version as it is now Is there a redistributable version of the Cypress runtime available yet Thanks, Ken Slovak Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 5
    - 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 Please advise on Add-in Express Office
  - 6
    - COM exception when trying to add picture as inline shape in Word 2007 RTM Hi Cindy, To be very specific, this issue only occurs when you try and insert an inline picture inside a xml node. I used a simple text box. The first occurance which I posted earlier was on a machine which was not a clean installation(meaning uninstalled Office 2007 beta and installed RTM on the same machine). Today, just to confirm, I went ahead and did a clean installation(Windows XP SP2+ Office 2007 RTM) and the COM exception still occurs. Cheers Babu Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 7
    - Word add-in and winform control Thank you for your answer ! But if you follow the link i gave, you will see how to insert winform control into word using add-in. I tested, it works however, i can't insert my control (registered as COM) in a inline shape (as describe in the article). Edit : For saving winform controls, there is a problem : when the document containing usercontrol is saved (file/save as), no code is executed after the next opening (the document is now a classic one). So i can't create the control again. I really thank you for all your confirmations ! Eome Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 8
    - Is VSTO SE for Outlook 2007 in beta ? Hi, I want to know whether VSTO SE for Outlook 2007 is in beta Thanks Kulvinder Singh Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 9
    - Word VSTO Issue. Hi Cindy, Yes, Initially the code was developed in a computer that had both frameworks installed. I then removed .Net 1.1 and recompiled the deployment project again. Thanks, Murali. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 10
    - Previously working code breaks when VSTO2005 is installed? Hello, I have previously developed some applications using the ActiveX OUtlook View Control. These applications were working fine. I then installed the VSTO 2005 developers kit. Now, when I first re-opened the solutions that had my working code, I recveived a warning about newer versions of the assemblies that I was using, so I clicked on the warning and VS apparently re-referenced the newer versions. I then try to compile, but I received an error about a missing reference to the Microsoft.VisualStudio.Tools.Applications.Runtime assembly, so I add that to my list of references. The application now compiles again with no problems. However, when I run the application, I get a null reference exception when trying to access the Outlook.Application. Here are the pertinent to lines of code: this.outlookApp = new Microsoft.Office.Tools.Outlook.Application(); this.outlookNS = this.outlookApp.GetNamespace("MAPI"); The second line is the line that reeives the null reference exception. However, in the debugger, the this.outlookApp object is not null. Does anyone have any ideas why this just broke And, just for reference, I am using Outlook 2003. Thanks! Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 11
    - Word ribbon customisation not working Hi I realised my mistake this morning - I'd got the tab id and button id in the XML set as the same value. This didn't trigger any warnings, but obviously stopped it from working. Thanks Paul. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 12
    - Remove borders from Excel charts using C# Thank you for the advice, but I have tried that to no effect. It still does not work properly. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 13
    - Send email using Outlook (Question 2) Thanks Helmut, I agree that is unwise to use Outlook on the webserver to send emails. I'm trying now to learn to use the the Virtual SMTP Server in IIS. Does anyone know offhand any good websites/advise on how to use the Default SMTP Virtual Server Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 14
    - Question re the CRM Integration Add-In Sample For Outlook 2003 (2) Wee Bubba wrote: My question is this. What if I wanted to take the data/UI separation one step further for this model for an Outlook 2007 add-in What if I wanted to avoid the synchronisation issue between the Outlook and MSSQL data by saving only to the database. To achieve this I could override the OnWrite event to save the contents of my custom form only to MSSQL. This is easy. But what about presenting that data afterwards within Outlook for viewing, editing and deleting I am not sure this is possible. For example, as far as I can see, when I click a folder there is no way for me to override the custom Views logic to perform a SELECT query on the MSSQL data rather than looking at the default Outlook store. Your analysis is correct. Outlook can only show items present in the store. The alternative to saving items in the normal Outlook store (.pst or Exchange mailbox) would be to provide a custom MAPI information store that directly exposes data from database tables. This is the approach that third-party tools like SQLView take. Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 15
    - VSTO - Excel 2007 Sheet Template Dennis, I just want to confirm... In order to create sheet level projects I need to do it Office 2003. In order to create Add Ins, I use Office 2007 (from what I understand, having 2003 and 2007 on the same machine doesn't work all that well). I am missing something Is VSTO SE just half baked and an interim solution Thanks, Tom Tag: Visual Studio Tools for Office Please advise on Add-in Express Office
  - 16
    - Outlook: MAPI fields versus User Properties Somethings like warnings when closing a mail saying: "The message has changed, do yo want to save...." or if you save a message in drafts and later open it and make some changes, when yo want save it, a warning appear saying that a copy will be made in origin folder, so you have a copy in inbox too, later if yo close outlook , when you open it again and open the message in drafts folder the last changes does not appear, but in the copy in inbox the changes are....... Behaviors like this happen in PCs which have my outlook addin installed, I assume that work with mapi fields are the problem because if I ommit set mapi fields this behaviors does not happen. Thanks for your help, Mauricio Tag: Visual Studio Tools for Office Please advise on Add-in Express Office

LastHope

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

Top

Re: Visual Studio Tools for Office Please advise on Add-in Express

X4U

Hello LastHope,

VSTO supports only Outlook 2003 und higher.

Programming Outlook with .Net is only supported from Outlook XP and upward.

If you want to be compatible with Outlook2000 and upwards, you should not use .Net and the best option here is using VB6 or C++.

(just my personal thoughts)

Greets, Helmut

Top