I am trying to work out a solution to share most of my VBA codebase across workbooks. This involves creating a .xlam file that would contain the shared modules & classes (+ their respective factories). I'm willing to use Office 2007's wonderful RibbonUI, and have that .xlam file declare a custom tab (Let us call it MyTab for the sake of...
I have a Visio Addin written in C# that add a custom CommandBar to Visio. The MSDN documentation mentions that the Visible property of the CommandBar is False by default. However, my CommandBar is being displayed by default when my Addin starts (even If I force the visibility to False). What is strange, is that it happens only at startu...
Long ago writing VBA macros for MSFT Office was part of my job. Now it looks like I may be traveling down that road again, and I have not touched MSFT Office for anything serious in years. Is VBA still the de-facto standard for creating msft office extensions? Is it possible to write (non-second-class-citizen) MSFT office extensions i...
I have asked this elsewhere, but have never found anyone knows how to build an add-in for VBA IDE using VB.NET. Is it even possible? Could someone point me to an example? ...
I have an excel add-in that keeps coming back when I start excel, even though I've removed it from the last open instance of excel (yes I checked the processes in task manager). The critter even shows up when I start excel in safe mode. Anybody else had this? ...
I'm looking for a code navigation addin for Visual Studio 2008: Press a keyboard shortcut to invoke a popup window that shows a list of methods of the current .cs file. In the popup window the input focus auto sets to an input box where you can filter the method list as you type. Press to jump to the selected method. That's all. Whe...
I have a handy little add-in that I developed for MS Office apps that I would love to use in Visual Studio 2008, which is not ribbon-based. Is there a way I can display my ribbon-based add-in interface inside of VS 2008? ...
I am a newbie with addin programming and need help with the following scenario. I have an C# excel automation addin that calls a few UDFs. I want to do a user name and password check during when the automation addin loads for which a screen where the user can enter his details must pop up on load of the add in. How can it be done using ...
I've created a powerpoint COM add-in by using the VS2005 Shared Add-in template. I managed to deploy the add-in succesfully, but I noticed that once I install the add-in, even after I shut down powerpoint, POWERPNT.EXE proccess remains running (as I can check from the task manager processes panel). I did some testing and turns out the b...
We are developing Outlook 2007 add-in. For testing outlook category renaming I've added the following code block var session = Application.Session; var categories = session.Categories; var category1 = session.Categories[1]; //catefory1.Name is "Group1" before executing line below category1.Name = "TEST!!!"; Marshal.ReleaseComObj...
I am a Delphi Transplant to .Net. I really like it, but I am missing one thing that I am wondering if there is an addin for. In Delphi there is an addin (called GExperts) that allows you to make your files show in rows at the top of your code window (rather than just one row that only shows as much as can fit). Is there something like...
I want to use C# class methods in Excel. Can anybody guid me how to do it ? The C# component will be excel add-in. How to create setup for this addin, so that I just need to give setup to user which will install add-in at client's machine. User should not need to do any other steps like registering the C# dll. Thanks in Advance. -- Rob...
Hi I am looking for a Visual Studio Addon which does standard Regular Expression Find and Replace, not the Microsoft Visual Studio version of Regular Expression As you do not get the complete syntax Please help? Thanks ...
Hi, I want to create a Method in Excel Add-In 2007 solution which can be called from my Excel Workbook 2007 solution. I explain, I want to call a method of Excel Add-In from code behind file of excel workbook 2007 solution. And I dont want to use VBA Macros. Please help, thanks in advance Thanks, Mrinal Jaiswal ...
I have an Excel add-in I am developing that works fine in Windows XP. However, I just got a hold of Windows 7 Professional and now I cannot save this add-in, either manually from the VBA Editor or programmatically using ThisWorkbook.Save. The error message says "Micrsosoft Office Excel cannot access the file 'C:\Program Files\Microsoft...
Hi, I have a very simple Excel Addin build it in Visual Studio 2008 for Excel 2003, which creates a toolbar with some buttons. When I debug it, with System Format set to "English (United States)" it works great, without problems. However, this addin is going to be used with System Format set to "French (France)" too, and when I try to...
Hi, I've created an Add-In for Visual Studio 2008. The only thing remaining is to create a setup package so that others can install and use my Add-In. How can I do this in Visual Studio? I tried creating a simple setup package, inserting files into the Add-Ins folder in the user's Documents folder, and it all worked as expected, except...
Hi I'm trying to write application-level add-in for Word 2003. The plugin adds a button on a new commandbar - clicking the button saves active document and then performs some additional actions. When I launch Word 2003 and then click my commandbar button everything works fine. However if I launch Word 2003, open a new Word window by...
Hi, I have a C# class library project for an automation add-in for which I have created a Visual Studio set-up project. When I run the installer, I want the add-in to appear in the Excel automation add-in list (Tools-->Addins-->Automation Addin) so that I can directly include it in my Excel application. How do I go about it? I created...
I have two MS Office add-ins written in VBA that I would like to package into an installer, along with some support files. Since VB passwords protecting add-in code can be hacked pretty easily, I want to "convert" the VBA code in my add-ins to DLLs, then call the DLLs from the add-ins. What are my options for "putting" VBA code in DLLs...