VBA SDK for Office 2007 Add-in

Visual Studio Tools for Office

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

- Previous
  - 1
    - Strange export to Excel Hi, I am using Access 2003. I have created report in my application. On preview I see the all data and the summary rows. I do the save as Excel 2003 and I got that summery rows through partically. The column where I sum data is passed to excel but other columns (that is data from rows group) didn't pass. How can I solve it Thank's Alexei Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 2
    - Setup has detected that the file vstor.exe' has changed since it was initially published? Darryn , I could come out form that issue. Thanks Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 3
    - Outlook Synchronization with Redemption (was: How to schedule the retrieval Outlook Items in the background?) Sue, Thanks for your thoughts on this issue. Since my OP in August I have been in contact with Dmitry Streblechenko, author of the Redemption library. The next version of Redemption, due in late November or early December, will expose the Incremental Change Synchronization API. I have been testing a beta and it looks really promising. Tad Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 4
    - Outlook 2007 BeforeFolderMove event Hi Sue, thank you for showing interest helping me. I'm trying to move just one folder! To make a subsciption, I tried two approaches: 1. During the add-in initialization, I subscribed to 20, 30 or more folders. I noticed that the event is fired only for the first 10-15 subscribed folders. Also, for those fired events I get one more problem. If I select folderA and try to move folderB to f.e. folderC using d'n'd, when the event is fired, Application.ActiveExplorer().CurrentFolder is still folderA. How can I get at this point information that the event is fired on the folderB 2. Second approach was to subscribe to this event inside the Explorer_FolderSwitch event handler. Here I got again problem that the seected folder is not the one I'm moving, because during the d'n'd Outlok does not select moved folder and Explorer_FolderSwitch isn't fired. I didn't find any way to get info about the by d'n'd selected folder. Hope I clearly described my situation, Sasa Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 5
    - ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Tim, First of all, do you have the VBA project system enabled You can check this in Excel 2003 by opening Excel and clicking on the "&Tools | &Options..." menu command, selecting the "Security" tab, clicking "Macro &Security..." and checking that "Trust access to &Visual Basic Project" is checked. If you have successfully created and built a VSTO 2005 solution on the machine in question this should already have been selected for you, but it is worth checking it manually. If the VBA project system is not enabled, try enabling it and running the server document code again. If VBA project is enabled already or the server document code continues to fail, please create a new empty Excel workbook, save it to the file system and run the server document code against this file. Does this fail also If so, could you please supply the error code and call stack. If not, please let me know. Best regards, Richard. SDE Visual Studio Tools for Office Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 6
    - Outlook 2003 - Appointment's label information Hi In outlook 2007 there is a Categories Class that holds the current categories as a String and can be managed through system dialogs like ShowCategoriesDialog Method of the AppointmentItem, but I have a strong feeling thinking that this wasnt available in the same level in Outlook 2003. Regards Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 7
    - Visual Studio 2005, display in secondary monitor help. Thase, this is mostly a PowerPoint issue- not a VSTO 2005 SE one, and those of us hanging out on this forum are mostly experts in the latter rather than the former. However, you are in luck! I know some of the PowerPoint programmability MVPs, and I know that they are monitoring the ng's for PowerPoint dev. You can find out more here: http://msdn2.microsoft.com/en-us/office/aa905465.aspx Look at the Newsgroups and Community links. Best. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 8
    - COM Exception in CommandBars["Task Pane"].Visible = true Task Pane definitely exists. I can open it by hand through the View menu or CTRL-F1 Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 9
    - Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Douglas, Thanks for this helpful reply. I will go ahead and install the Windows Server 2003 Platform SDK. I have to admit that I never would have guessed that that's the package being referred to in the article. I appreciate your help. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 10
    - Can't get Wordeditor property from the Inspector.Activate event in the Outlook07 Thank you for your answer! So in the case which I described, is there any work around to get the Wordeditor Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 11
    - Mdac i am trying to add to my vs2005 the vstools (to add a new pane to a office word) amazingly no metter what i try. the installation failed something about Mdac...... i do not want to uninstall my vs2005 but it seems that all the roads send me there.... how do I know what is my mdac and how can i downgarde it Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 12
    - beforeSave or.... I have an excel file . When modifications are made to the file and the file is saved,I need to trigger some actions.These actions would imply copying the file to another location and from there,importing it to an sql table... Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 13
    - How to add words to MS Word custom dictionary Thanks for the answer, but there is a problem with that approach. After MS Word unlinks the dictionary it stays as a deleted object. When you add it again in MS Word there is no problem, but the next call to the ActiveCustomDictionary throws an exception “Object has been deleted.” This could be easily shown by trying to add to words to the dictionary Best regards Stoil Pankov Private Function AddToCustomDictionary( ByVal wordToAdd As String ) As Boolean Try Dim customDictionaryFile As System.IO.FileStream Dim customDictionary As Microsoft.Office.Interop.Word.Dictionary Dim filePath As String = "" Dim byteArray As Byte () Dim encoding As System.Text.Encoding encoding = System.Text.Encoding.GetEncoding(1251) If Not wordApp.CustomDictionaries.ActiveCustomDictionary Is Nothing Then With wordApp.CustomDictionaries.ActiveCustomDictionary filePath = .Path & "\" & .Name ‘ Here an exception is thrown the second time the method is called End With customDictionaryFile = System.IO.File.Open(filePath, IO.FileMode.OpenOrCreate) customDictionaryFile.Position = customDictionaryFile.Length byteArray = encoding.GetBytes(vbNewLine & wordToAdd) customDictionaryFile.Write(byteArray, 0, byteArray.Length) customDictionaryFile.Flush() customDictionaryFile = Nothing customDictionary = wordApp.CustomDictionaries.Add(filePath) wordApp.CustomDictionaries.ActiveCustomDictionary = customDictionary End If Return True Catch ex As Exception Throw ex End Try End Function Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 14
    - Newly Added Document is NOT the Active Window Ji, I'm using VSTO and I think it's VSTO SE since I downloaded the latest version. Just to make sure, how will I confirm that I got VSTO SE installed All the functions and forms I used are all contained in a class library written in C#. Its a separate dll that is being use by the add-in. The add-in will just call the function that loads the form, and when a button on that for was clicked, it will use the library function that create the document and make it active. The CreateDoc() function was contained on the library. I create the project using the templates that I downloaded from microsoft web sites. I create the new add by clicking on File --> New Project --> Visual C# --> Office --> 2007 Add-ins. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 15
    - Excel automation : formating dissapears Hello, I need to format a formula in a cell on an excel sheet. I'm generating the sheet completely from code that I wrote in VB. So I figured out a way to express my formulas in such a way that I can create them programatically and interpret them later on to make them show correctly on the sheet. I need to put some parts of text in subscript. I tried it several ways: cell.Characters(st, ln).Font.Subscript = True directly in vb code will at best put everything in subscript. Another option I ended up implementing was a simple macro piloted by the two integer values that works on the active cell. It works as far as I could see but the formating dissapears once I change the active cell and it is very slow! Can anyone please help me, I need a solution for this problem before I continue coding some more of my industrial plant. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 16
    - Undo and Redo in Office automation in .Net 1.1--Urgent Help needed Is there anyway to do in c# I need some c# code Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
- Next
  - 1
    - Excel worksheet ActivateEvent You should be able to add a simple event handler such as this (add to Sheet1.vb for example). Private Sub Sheet1_ActivateEvent() Handles Me .ActivateEvent MessageBox.Show( "Activated" ) End Sub If that doesn't work - you'll need to provide us with more details on what you're trying to do. Regards, Steve Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 2
    - Outlook addin stops responding Hi John, Our outlook plug-in is built to synchronize calendars between Google and Outlook. Now what our automatic synchronization feature does is, whenever outlook opens after a specific period of time (say 15 min) our add-in starts synchronizing calendars. But there is a catch. sometime this features freezes the Outlook. It doesn’t happens every time. But when-ever it does user has to kill the Outlook process and restart the Outlook (or sometimes his system). There are elaborate try catch blocks in our system, but still no where we could catch this error. Also once when automatic synchronization was happening and I was changing/shifting between different mail folders and suddenly it froze. No exception was thrown (as plug-in was still running in debug). Sorry I could not post code but I am jotting down brief description of process: forms Timer is started (for 15 min in the ThisApplication) after 15 min Tick event is raised. Open sync form and hide it (visibility false and hide in task bar). In this sync form a background worker is used to complete the synchronization process. Once process is complete form is closed. I would appreciate any help. Thanks Regards Sid Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 3
    - Exchange Server, Outlook and VSTO The setup: Exchange Server 2003, Outlook 2003, VSTO 2005 SE, Visual Studio 2005, .NET 2.0, Windows XP SP2. The problem: When composing a new email Outlook resolves the email address with the user's full name (if it is known). For example, if I write the email: jsmith@company.com , the it would be resolved to "John Smith" and shown as an underlined link in the "To" text box. I have searched the web and found that it is possible to use some external libraries to get the address from the name (eg: CDO, Redemption, etc.. ). My question is whether there is a way to stop Outlook from doing this name-email resolution in the first place. In other words, is there a way to stop converting jsmith@company.com to "John Smith" Thank you in advance. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 4
    - Access controls in different document instance (VSTO 2005) Hi, I hope you have found a solution to you problem =) anyway, I was wondering maybe if u could help me out since you mentioned that u have attached the VSTO customization to a document through ServerDocument. this is the code i am using: if(ServerDocument.IsCustomized(FilePath)) { ServerDocument.RemoveCustomization(FilePath); } ServerDocument.AddCustomization(FilePath,..... etc); this piece of code works perfectly when i deal with a VSTO word document (already attached to customization). However, when i use it for an ordinary word document, the call to AddCustomization fails with a COMException. i appreciate your time & efforts Maha Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 5
    - Replacing entire folder view with custom user control. (Outlook 2007) This sample is for Outlook 2003, I'm trying to get this to work with Outlook 2007. I was referred to this by a developer here, but he said this solution will only work for Outlook 2003, which I have also tried and found out. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 6
    - Fixing Bad Office.Core Refernce in xl2003 Application Add-In Cindy, Thanks for the reply and sorry for not annotating this earlier. Complex answer. I tried the Office 2007 beta but uninstalled it (perhaps it did not fully uninstall). I have purchased OneNote2007 and use it, but not Office2007 in general. If i look at the properties reference to Microsoft.Office.Core in my AddIn solution, it says "Microsoft Office 11.0 Library" in the description, but the path property is C:\WINDOWS\assembly\GAC\Office\12.0.0.0__71e9bce111e9429c\Office.dll The setup project is deceting 2 dependencies to office.dll, the 12.0 and 11.0. I can easily delete the bad reference....I just can't see how to get the right one in there inside visual studio. Greg Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 7
    - How to use XP visual Styles on an Office (Excel) Add-in Hello, I'm using Visual Studio .NET 2005 and I was wondering if nice XP Visual Styles can be applied to the windows and dialogs that i use on my office add-in. since it's a library i cannot check the checkbox "Enable Applicaiton Framework" neither "Enable XP Visual Styles". I've found this article but i'm using VB.NET and don't know how to translate the "using" statement. Can anyone help me or explain to me at least general steps to get this to work on VB.NET thank you Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 8
    - Creating Add-ins I am using Excel quite well, but I want to make something more on Excel. I want to prepare a custom menu, which includes some special statistical functions for special purposes. Which is the appropriate environment to develop an installable add-in in Excel Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 9
    - A Toolbar for MS Word 2003 Hi, Firstly thanks for your reply.I read that article.However i couldn't understand something from that article.My problem is that; Private Sub AddToolbar() Try commandBar = Me.CommandBars("Test") 'FIRST Catch ex As ArgumentException ' Toolbar named Test does not exist so we should create it. End Try If commandBar Is Nothing Then commandBar = Application.CommandBars.Add("Test", 1, False, True) 'SECOND End If Try At the line of FIRST :Itgive me error.Error is: CommandBars is not a member of 'wordAddin1.ThisAddin'.I changed 'Me' keyword and rewrite that line: commandBar = Application.CommandBars("Test"). (When i do this my program runs and don't give me an error while debugging)Is this an appropriate way to solve the problem and for which purpose we use CommandBars method If i make that line a command line (i mean if i write ' commandBar = Application.CommandBars("Test") ) my program runs properly again then why we need to use this method The last thing i want to learn is that: On the SECOND line if commandBar is nothing how we can use "Add" method without "initializing" commandBar.(I am new to Visual Basic and i have to make a project with Visual Basic this questions make seem you not professional but i need help to handle my project.) If you help me i will be very happy too Thanks Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 10
    - Excel Edit Delete Disabled Thank you for your feedback. You should not be seeing this behavior with solutions with ListObject in VSTO SE 2005 runtime . We have made some fixes in this region. When ListObject is activated it disables the Edit->Delete option, because deleting columns in databound ListObjects is not allow. However, it re-enables the option once ListObject is not in active focus. You should be able to delete non-ListObject cells, rows, and columns in any case. Let me know if this helps! Thanks, Nikhil Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 11
    - Assigning values to Custom Text boxes on a new e-mail form in Outlook 2007 I amd using VTSO. I don't want to use VBA in Outlook 2007, that's why I posted my question here. I will look into Outlook automation though. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 12
    - Target either Excel 2003 or 2007 Hi Nigel, Andrew Whitechapel's blog will tell you why VSTO does not support building one add-in for multiple version of Office. Look at this link: http://blogs.msdn.com/andreww/archive/2007/06/15/can-you-build-one-add-in-for-multiple-versions-of-office.aspx Wish this helps! :-) Thanks Ji Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 13
    - OUTLOOK 2003 Resource Booking ?????? Using VSTO 2005 If the resource is set for direct booking, there will be no accept or decline message. Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 14
    - Executing default SmartTag Action Menu Item programatically... Thanks Cindy, I was looking wrong way of doing this. Appreciate your reply. The only reason for choosing this forum is Vsto SmartTags.Add( ) method. The Vsto clicks me to post my question here. Well, i'll be more carefull in choosing forums next time. Once again thanks for solving my problem. -Syed Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 15
    - Should I be using SE? I've got an Excel 2003 project in Visual Studio 2005. One dll is produced. It runs fine in the Release (or Debug) directory. However, if I publish to my local webserver, or if I copy the files anywhere, then it wont run. Excel comes up, but it tells me "The current .Net security policy does not permit the customization to run. Do not change the security policy in your computer. The .Net security policy is controlled by your administrator blah blah blah blah" ... So next, I tried to use the OfficeVSTOWindowsInstaller projects from: http://msdn2.microsoft.com/en-us/library/aa537179(office.11).aspx It seemed to work fine. I followed the instructions to the best of my ability, double-checking everything. However, when I try to run the installer, it says "Exception occurred while initializing the installation: System.Argument.Exception: File assemblyName=Closed_Loans _Report_Queue.dll does not exist." The thing is, it does exist, and so I'm trying to figure out what I might've done wrong. My CustomActionData for SetSecurity is: /assemblyName="Closed_Loans _Report_Queue.dll" /targetDir="[TARGETDIR\" /solutionCodeGroupName="Bank of Oklahoma.Closed Loans Report Queue" /solutionCodeGroupDescription= "Code group for Closed Loans Report Queue" /assemblyCodeGroupName="Closed Loans Report Queue" /assemblyCodeGroupDescription= "Code group for Closed Loans Report Queue" /allUsers=[ALLUSERS] Is the problem here or somewhere else Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office
  - 16
    - Template changes when creating new document? Thanks - we'll try that. That sound like a nice workaround, though it gives me no explanation on why this occurs... But anyway, the most important thing is to ensure our users aren't annoyed by this popup always. /Anders Tag: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in Office

Priyanka Siwach

Hi All,

Which version of VBA SDK should be used to build Add-in for Office 2007 developed in VC6.

regards

Priyanka

Top

Re: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in

Dennis Wallentin

Priyanka

This forum explicit target VSTO so please have a look at the following URL to find a more appropiate forum:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=174275&SiteID=1

I use VBA SDK 6.4 but I'm not sure if MSFT has relased a more recent version.

Top

Re: Visual Studio Tools for Office VBA SDK for Office 2007 Add-in

Misha Shneerson - MSFT

Do you need to have a VBA SDK to develop COM Add-In in C++

I did not think so - all you need is to implement IDTExtensibility2 interface.

To import your interface you can either use:

#import "c:\program files\common files\designer\msaddndr.dll"

or the following path independent version of same import (copied from this post by Mr. Whitechapel who has done couple of C++ COM Add-ins for Office).

#import "libid:8ABE10B3-E686-4c81-8F15-866EF405B4C9" raw_interfaces_only named_guids

Top