Best VBA add ins

VBA Add-ins with & without Ribbon Commander. Functions for Excel 2013 tutorial Add-ins. Add-ins are available in several languages with translated Excel functions. The 2048 Game for Excel. This is an unblocked Excel version of the official 2048 game by Gabriele Cirulli. FIFA World Cup 2014 free prediction template The VBA Code examples add-in is a free add-in for Excel / VBA that comes with 150+ ready-to-use VBA code examples & macros. AutoMacro - The Ultimate VBA Add-in AutoMacro is an add-in that installs directly into the Visual Basic Editor Before we go through the best add-ins, let's review first how to install and run the add-ins. After downloading the desired add-ins, simply run their setup files and complete the installment . To check, open Excel and click 'File' from the tab list The best free VBA developer tools. Posted by Felix Zumstein - Comments. Despite all the new possibilities to program Excel (like JavaScript add-ins, VSTO and others), VBA remains the most popular language when it comes to automate and enhance Excel. And just because Microsoft hasn't invested in either the language itself nor the VBA editor. Here are the best Excel add-ins to up your spreadsheet game. Labeling your charts is one of the best ways to make your data easy to understand. Use this chart labeler Excel add-in and your charts will be way less confusing. Insert a map right into your spreadsheets to plot locations and visualize data with this Bing Maps add-in

J. g. d. G. D. If you are developing COM, VSTO or VBA add-ins for Office, follow the development best practices described in this article. This will help ensure: Compatibility of your add-ins across different versions and deployments of Office. Reduced complexity of add-in deployment for your users and IT administrators 8. Take a look at this SourceTools.xla. It is not a IDE, but an add-in for VBA that allows to save/read the all source files from your project into actual text files for use with source control. I have been using it for at least a year and I am very happy. It even allows direct use if CVS or SVN source control systems for commits/diff, but you. 75+ of the best add-ins, plugins and apps for Microsoft Excel, free or not. Passer au contenu principal. Home. Features. Plans. Plans. Academic version. Request a quote. Book a demo

4. Excel Stock Market Functions - Free l This add-in provides new user-defined functions that can be used to retrieve stock markets data from the web directly into Excel. Using these functions, you can for instance download the market capitalization of a company by entering its market symbol, the dates of the period and the frequency of the quotes (ex: daily) The Readiness Toolkit for Office add-ins and VBA is designed to help organizations identify documents that contain VBA macros, assess the compatibility of those macros with Office 365 ProPlus, and provide add-in readiness information for Office add-ins. The tool does not repair or fix code This is the second best in the market and is undoubtly one of the most used excel add-ins. This is a feature rich and user friendly excel add-in. The add-in has capability to format cells based on different situation or criteria, more options to dice and slice data, formatting text cases and cleaning extra spaces in cells like invisible space

6. Analysis ToolPack - Free l The Analysis ToolPack is a Microsoft add-in that allows statistical analysis such as correlation analysis, descriptive statistics or histograms. It is provided on every computer using Excel 2007 and later, Mac or PC. You just need to load the add-in. 7. Solver - Free l The Solver is a tool that is also provided by Microsoft with Excel 2007 and later Add-ins created with .NET can be much faster, stable, and complex than add-ins created with VBA. From Excel-DNA's website : Excel-DNA is an independent project to integrate .NET into Excel. With Excel-DNA you can make native (.xll) add-ins for Excel using C#, Visual Basic.NET or F#, providing high-performance user-defined functions (UDFs. This is a bit of a workaround, but to get the COM add ins box to pop up you can use SendKeys to pull it up. Keep in mind that SendKeys only excutes at the end of a run on Excel 2010 onwards, so to get it working correctly you would need to check if the user is connected to the add-in first thing

AddIns.Add (generic.xll).Installed = True. Use AddIns ( index ), where index is the add-in title or index number, to return a single AddIn object. The following example installs the Analysis Toolpak add-in. VB. AddIns (analysis toolpak).Installed = True. Don't confuse the add-in title, which appears in the Add-Ins dialog box, with the add. Editor approved websites about Add-ins. Conveniently organized. Put your hard drive in motion with top websites created for and about the computing industry. Find leading consultants, explore news and reviews of computer sciences, software, open source projects, PC's and many other topics There are three different types of add-ins that you can consider installing. Excel add-ins. These include the add-ins that are already installed when you open Excel like, DLL add in (.xll) file, Excel 97-2003 add-in (.xla), or Excel add-in (.xlam). You should also have access to Solver and the Analysis ToolPak. All you have to do is activate them Vba com add ins developer tab in Excel Add Ins are built in programs that provide additional features to the users of Excel. There are a number of Add Ins available for every application of MS Office. Add Ins, by default, are not readily available, though some important Add-Ins are made available like Team foundation

Favourite Free Excel Add-ins. Excel has some powerful features, but it's not perfect. To add to its capabilities, I use a few free add-ins that make Excel even better, and asked other people what free add-ins they use, and would recommend.. NOTE: After a recent Microsoft update, some Excel add-ins (mine and others) are not loading correctly Before we jump into the add-ins, we need to understand the process of installing and managing add-ins in Microsoft Office. Using Excel for our demonstration (this is done the same way in most other Office applications), select the Insert tab then click the Get Add-ins button.. This will launch the Microsoft Store where you can search and install any add-ins you may need On the Tools menu, point to Add-Ins and click Browse. Locate your add-in from where you saved it, select it and then click OK. Ensure your add-in is in the Add-ins available: box and it is checked. Now click OK and the add-in is installed. Most code can be be saved to an Excel Add-in without too many changes. Some things to be aware of ar No need to know VBA programming or to be a developer. QTManager. QTManager Navigation Pane replacement Add-in for MS Access Download Free Access Add-ins for Microsoft Access. Download Free Access Addins for Microsoft Access. Download Free Access Add ons for Microsoft Access

Free VBA Add-ins for Excel & Powerpoin

VBA Code Examples Add-in - Free Download for Exce

  1. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=..
  2. Download Free MS Access Add ins Add-ins Addins Plugins Addons Tools Utilities for Microsoft Access www.access-add-ins.com I wish health to you and mankind
  3. Free Visual Basic or Visual Basic.NET Add - Ins. Free and value-priced Visual Basic controls and components. Generates documentation from VB source files. It parses source code and automatically creates table of contents. converts entire Visual Basic applications to 100% Pure Java
  4. Excel Add-ins Categories and Excel Add-ins Full List Excel VBA Add-ins List. Code VBA Code VBA is an essential add-in for both professional software developers and MS Office users who need the power of Visual Basic for Applications for automation purposes

The 7 Best Excel Add-Ins You Need To Get Now (Free & Paid

VBA Add-in (Free) to make Coding Easier. I've created a VBA add-in to help make coding easier (and to help beginners learn VBA): Over 150 pieces of code that you can easily insert into the Visual Basic Editor (Fors and Loops, Functions, Message Boxes, Text, Dates and Times, Objects, and Settings) You can save your own commonly used code. In the add-ins window, click the Store link, then use the search bar to find the add-in you want to install, and click Add.. It works a bit differently in Outlook. To install add-ins on desktop versions of Outlook, click the Store icon in the Home ribbon, then search for and Add the add-in as before Some are Microsoft Access Add-ins that run directly in your Access desktop environment, some run directly in your VBA/VB6 IDE (editor), and others are standalone programs. All were designed specifically for the needs of Microsoft Access professionals

Ultimate Add in (free) Ultimate add in is also one of the best excel add-in. The cost of the add in is totally free. Here is the small description of the add in. Ultimate Add-In will allow you to create bookmarks, find duplicates, increased no. of undos (up to 100), protect multiple sheets, remove worksheet/book protection, named range manager. MS Access - Plugins, Add-ins, Etc. One thing any good worker will tell you is that you must have the right tools to do the job. Computer programming, MS Access database development, is no exception to this rule! I thought I'd list a few add-ins, plug-ins, etc. that I have come across, or heard of. This is an unbiased listing and I have no. You will learn to customize different built-in functions of Excel using VBA. This source helps you to create message boxes, dialogue boxes, input fields, add-ins, content controls, embedded macros, and numerous other Office automation program. Mastering VBA for Microsoft Office 2016 helps you to become a master in VBA terminology Visit 5 best practices to make your VBA macro great blog article for the video demonstration of the practical application of the below guidelines. Descriptive Names. When developing any application (VBA is not an exception) try to use as descriptive as possible names for variables, functions, procedures, modules, classes and events

The best free VBA developer tools - Version Control for

Our Microsoft Excel add-ins will save you time and make Microsoft Excel easier to use. All of our add-ins work in Excel 2007 to 2019 and Office 365. All work in 32 and 64 bit Windows 7, 8, and Windows 10. All work in 32 and 64 bit Microsoft Excel. The Productivity Suite has all of our add-ins. The Spreadsheet Assistant is our most popular add-in You can get many useful Macros and Add-Ins for our free Macros and Add-Ins Tools section. Recording or Writing a Macro: A non-programmer can also record a macro and programer can make best use of it. Here we will learn how we can record or write macro step by step. You can perform these steps in Excel 2010, 2013, 2007 and 2003 More serious add-ins, such as those found in Windows store, or are released by major software providers (SAP, Oracle, Microsoft) write their add-ins with C+, JavaScript or VB.Net. There's colossally more coding libraries in these languages than VBA, and the output of a DLL file makes it much harder for people to steal their code (as the OP. Insert and create your very own tickmark icons to mark up your spreadsheets. Find plugs in formulas, hyperlink ticks, and so much more! Store your brand colors, headings, and logos directly inside your Excel Ribbon. Never type in an RGB color code again! Store all your custom number format rules to your Excel Ribbon giving you instant access to. Free PowerPoint Add-Ins. Here are 11 PowerPoint add-ins that will help you get your presentations done with the most satisfying results and without breaking the bank. These include apps for improving presentation design, a plugin for generating a QR Code, a tool for building e-courses, and many more

50 Best Excel Add-Ins That Will Make Your Life Easie

Become The Resident VBA Expert In Your Office. Results and cost savings are the main considerations when automating Office applications with VBA. The most elegant program that arrives late will take a back seat to an expedient solution that works when needed without involving the 'IT Guy'. Here is a collection of my hard-earned performance tips. This page contains an organized list of all the Excel files, add-ins, and guides that are available for download on this site. The majority of the downloads are free. Excel Add-ins. An Excel Add-in is a tool that adds additional features to Excel During the past 22 years our add-in has grown to become probably one of the world's most popular add-ins for Microsoft Excel. A must have for anyone who spends time in Excel Worldwide 750,000+ users and 23,000+ organizations use ASAP Utilities. We truly believe that ASAP Utilities is a must in every office. It's guaranteed that more than.

There are various Excel VBA programming books available, but it is good to have the best books to get great Excel training easily. So, in this article, you will get thorough information about 6. The right add-in can provide helpful features and make existing Office capabilities easier to use. Susan Harkins has rounded up a selection of handy add-ins for various Office applications The best way to do this is using an add-in. Sharing Code across Workbooks using Add-Ins (this blog) Useful Examples of Code to Share; Creating an Add-In; Using Add-In Functions; This blog is part of our Excel VBA online tutorial. Wise Owl also run excellent classroom-based VBA courses

Development best practices: COM, VSTO, & VBA add-ins in

  1. Useful Excel Add-ins, books and ? On this page you find links to good Excel Add-ins, books and ? from people I know and trust. You only find links in the list to products that I use or used myself so I know what I am talking about
  2. This project provides VBA add-ins which convert Microsoft Office contents to various text formats. Currently the following two VBA add-ins are ready. * xls2textile: Excel to Textile, HTML, AsciiDoc, GitHub Flavored Markdown (GFM), and CSV. * ppt2textile: PowerPoint to to Textile, AsciiDoc, and GitHub Flavored Markdown (GFM). 2021/02/06: Version.
  3. So Microsoft released Excel JavaScript in 2013, a language intended for use by add-ins and more convenient than VBA. Excel JavaScript has similar uses as other add-in languages
  4. This meant that all add-ins created with VB6 for its VBA editor stopped to work, because they are 32-bit add-ins. The only possibilities to create 64-bit add-ins are using C++ 64-bit, or using .NET x64 and COM Interop. So, it is not a surprise that quite a few add-ins for the VBA editor are created now using .NET
  5. Download Essential Excel Add-In for free. Essential Excel Add-In is a Microsoft Excel Add-In, written in VBA, that contains useful User Defined Functions (UDFs) and macros to performs a number of different tasks that either Excel does not provide (Regular Expressions (RegEx), improved VLookUp)
  6. Open an Excel workbook and Go to Developer -> Add-ins -> Excel Add-ins. In the Add-ins dialogue box, browse and locate the file that you saved, and click OK. Now the add-in has been activated. You may not see any tab or option appear in the ribbon, but the add-in gets activated at this stage and the code is available to be used now
  7. ating annoying spam, and organizing your inbox. We gathered a list of several useful Outlook add-ins to make.

Office add-ins provide this kind of added functionality to Word, Excel, PowerPoint, and other Microsoft Office apps. Here are some of the handiest add-ins you can install for Office 2013 and above. Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available Taking the Step from VBA to Autodesk® Inventor® Add-ins 2 Introduction If you've done any programming with Inventor you've likely heard about add-ins. This paper is written for users of Inventor's VBA and would like a better understanding of what an add-in is and how they're created. The following questions are addressed: 1 Word, Excel, and PowerPoint add-ins. Effective February 1, 2017, Word, Excel, and PowerPoint add-ins that use the taskpane manifest must use add-in commands in order to pass Office Store validation. This policy will apply to both new submissions and updates to existing Office Store add-ins This is truly one of the best and most useful add-ins I've ever used. Download from www.asap-utilities.com : MZTools by Carlos Quintero. This is one of the best add-ins for the Visual Basic Editor ever written. It provides hundreds of tools to make coding easier. Available free from www.mztools.com

VBA Macros - Message Bar

FMM is a excel add-in to generate a formulae map of the Financial Model which help in reviewing complex financial models. macro financial model vba model review excel add-in. 415 Discuss add_shopping_cart. $99.00. by Financial Modeler Create Office add-ins in .NET Add-in Express for Office and .NET is your all-in-one framework for developing commercial class extensions for all applications and all versions of the Microsoft Office suite, including Outlook, Excel, Word, PowerPoint etc

excel - Recommended IDE for VBA - Stack Overflo

75+ of the best add-ins, plugins and apps for Microsoft

  1. Weekly blog posts, YouTube tutorials, macros, VBA add-ins, and online training programs to help you elevate your skills and become an Excel Hero
  2. Click the File tab, and then click Options. In the Options dialog box, click Add-Ins. In the Manage list at the bottom of the dialog box, click PowerPoint Add-ins, and then click Go. In the Add-Ins dialog box, click Add New. In the Add New PowerPoint Add-In dialog box, browse for the add-in that you want to add, and then click OK
  3. The 51 best Outlook email add ins and plugins are listed below. They're categorized based on what a user might need in terms of additional functionality. Outlook has many versions and not all plugins may work with the version you're using. Some add-ins are paid, so we've listed the top free plugins as well
  4. This 3rd party software says it's new version is available for Outlook on Windows 2019 with this note - Outlook should be connected to Office 365, Outlook.com or Exchange 2016+. I am not able to install the new version on our current Desktop Outlook. The Get Add-ins button is greyed out. I have gone through support articles and checked the.
  5. If you are using Excel 2010-2019, click File, Options, Add-ins, change the dropdown box to COM add-ins and click Go. February 5, 2013 update: We have found that the above will not remove all COM add-ins . Some avoid the Microsoft Excel COM add-in dialog and must be removed manually. To do so, you will need to edit the registry
  6. Select the Store button or the Manage add-ins button on your add-ins bar. On the Office add-ins page, you can do the following: Search for new add-ins. Use the options on the toolbar to add more add-ins, uninstall an add-in, or refresh the page to see a list of the latest add-ins. Turn an add-in on or off by sliding the toggle switch

Excel Add-ins. Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets. With Devart Excel Add-ins you can get exactly the data you need with visual Query Builder or with SQL and refresh the queried external data in a workbook any time with a single click These include certain custom Component Object Model (COM) add ins, VBA add ins and XLL add ins. So once developed, you need to first install these add ins to use them. 3. Downloadable Add Ins. These add ins are developed by Microsoft. However, they are by default, not shipped along with your normal Microsoft Excel package Data exchange between VBA and Excel add-ins When passing data between your Excel COM addin and VBA functions, you'll need to keep an eye on how VBA interprets different types of data. For example returning a string array from a function in an add-in requires you to not explicitly return an array of string values, but rather an object as. VBA Add-ins and Tools (Free) MZ Tools. If you do any VBA developing, you need this addin. It is loaded with useful tools such as a code reviewer and much more to speed up your development process. PDF Creator. A free PDF writer utility that supports VBA

VBA Code. COM Add-ins Using Default Security In Microsoft all COM add-ins that run on a computer, not configured to obtain security settings from a Microsoft Exchange Server, are considered trusted by default. This implies that the add-ins that run on clients that are not Exchange clients and the add-ins that use default security in Exchange. Usually, we create Add-Ins by using VBA macros VBA Macros VBA Macros are the lines of code that instruct the excel to do specific tasks, i.e., once the code is written in Visual Basic Editor (VBE), the user can quickly execute the same task at any time in the workbook. It thus eliminates the repetitive, monotonous tasks and automates the process. read more Try File > Options > Add-Ins to see what is already available within your version of Excel. If you choose to download an add-in, you can use the Add-Ins Manager to install it. Now, it's time to push Excel to the limit. Let's go over some of the best Excel add-ins that make it easier for you to find, process, and analyze your data

VBA Macros - Trust Center

Development best practices for COM, VSTO, and VBA add-ins in Office. If you are developing COM, VSTO or VBA add-ins for Office, follow the development best practices described in this article. This will help ensure: Compatibility of your add-ins across different versions and deployments of Office Excel: Tools, Add-Ins, and Macros. Included here is the start of a much needed compilation of Excel add-ins, macros, and tools. For the one person who'll read this, please add your most frequented excel shortcuts, and own collection/links of Excel Add-Ins/Macros/Tools in the comments down below. That way when any new WSO users search for Excel.

DiscoverSim is bundled with SigmaXL Version 7 and is an Excel add-in for Monte Carlo Simulation and optimization. It provides 53 continuous and 10 discrete distributions, with distribution fitting and automatic best fit. Sensitivity analysis is supported based on correlation or stepwise regression and includes quadratic terms Maurizio La Cava makes presentations every day and makes extensive use of PowerPoint add-ins, so he has put together a list of what he considers to be the best ones, grouped for top functions and discusses them in detail below. With millions of presentations delivered every day, PowerPoint has become a core tool for anybody [ Professional Excel Development. by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001) Excel 2002 VBA: Programmers Reference. Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green. DonkeyOte: My Recommended Reading, Volatility Custom Add-Ins. Developers can create component object model (COM) add-ins, VBA add-ins, and XLL add-ins for you the Excel community to download and install. Microsoft opened up their code base and made it possible for third-party developers to get creative

VBA code to document hyperlinks in the Active Workbook. Add-ins Free and not protected so you can learn since these are just ACCDBs that have been renamed. Goto Top : How-To How to make an add-in An add-in lets you run code in any database without having to create or import modules.. Download this Excel addin which is probably one of the world's most popular addins for MS Excel, find out yourself and save also many hours of time! Over 300 useful and powerful utilities to fill the gaps in Excel, and automate frequently used tasks. Freeware for home use, students and charitable organization Select the COM Add-Ins from the drop down menu and then click the Go button to open the Add-Ins configuration window as shown below. Disable VBA AddIn: Simply uncheck the add-ins you wish to disable and then click the OK button. I recommend restarting Outlook afterwards to make sure the changes take Excel Add-Ins. An Excel Add-In is a file (usually with an .xla or .xlam extension) that Excel can load when it starts up. The file contains VBA code that adds additional functionality to Excel, usually in the form of new functions

Download Readiness Toolkit for Office add-ins and VBA from

If you don't see the add-ins icon or you're unable to access the list of add-ins, then you'll need to check your add-ins status. To do this in Outlook, click on the File menu, and then click the. The best example I can give is using a macro to create a pivot table. Create a Custom Excel Function: With VBA, you can also create a Custom User Defined Function and use it in the worksheet. Create Add-Ins: In Excel, you can convert your VBA codes into add-ins and share them with others as well The installation process is similar to installing a local add-in, but with one important difference. The steps to install an add-in in a network environment are: Open Excel. From the Tools menu, select Add-ins. Click Browse and browse to the F:\Addins directory. Double click your add-in You load and unload add-ins in Excel 2016 by using the VBA Add-Ins dialog box. To display this dialog box, choose File → Options → Add-Ins. Then select Excel Add-Ins from the drop-down list at the bottom of this dialog screen and click Go. Or take the fast track and choose Developer → Add-Ins → Add-Ins. But the easiest method is to just [ VBA, iLogic, add-ins, and external EXEs, and some of the reasons you would choose one over the other. The class will cover how to create an add-in using an easier-to-use custom VB.NET template. We'll look at the differences between VBA code and VB add-in code and how to convert your existing VBA macros and iLogic rules into add-in commands

The Best Excel Add Ins For Excel Users - Excel Zoo

70+ of the best add-ins, plugins and apps for Microsoft

I am concerned about the Excel VBA add-ins., e.g. *.xlam files.) (3) The same fate happens to the Excel add-ins when Excel is launched by some third-party non-Office program as e.g. a Reverse-PDF-to-Office program. (4) As another observation, I checked whether PowerPoint would behave in the same improper way when launched from Excel or Word Excel. Add-Ins. Create Microsoft® Excel® add-ins from MATLAB ® functions. You can use MATLAB code in Microsoft Excel by creating Excel add-ins. These add-ins can take the form of custom functions or can be integrated with Excel macros using Visual Basic for Applications (VBA)

Best Excel Tutorial - How To Activate and Use The Inquire Tab?

Excel Automation Tools (Best of List) - Automate Exce

Microsoft Actions Pane 3 - logicnitro

Add-ins Tab. If you have any third party add-ins installed then these will be displayed on an additional Add-Ins tab. This tab will contain any commands that were previously added to menus or toolbars. Two groups will be displayed one called Menu Commands and one called Custom Toolbars. Changes made to toolbars and menus using the old. Click the settings COG in the top right corner. There are two different ways to get in from here: click MAIL (near the bottom left) or. click SETTINGS. Expand GENERAL > ADD INS. Select the Add In you want to remove and click the minus sign '-' at the top. Restart Outlook and have a nice day Putting add-ins on network shares rocks. I can install the add-ins on client machines around the office and be sure they'll always be running the latest version. My understanding is that this is not best practice, though I don't recall exactly where I read this (Either PED or Programming Excel with VBA and .NET)

Electrical Engineer (2004-present) ·. May 21. I haven't done much work with both Python and Excel, but when I did I used openpyxl. [ 1] It's a Python library with functions for interacting with Excel worksheets, particularly in the newer .xlsx format. For my purposes I merely read Excel files Do this for Excel Add-ins drop-down menu too. This will activate GuruFocus ribbon in the menu. In Earlier version: This is usually caused by your Windows Office security settings. Click the Office icon in the top left of the Excel Workbook, then go to the Excel Options. Find the Add-ins button in the left menu Using Excel and VBA to Implement Risk and Simulation Models 194. Generation of Random Samples 194. Repeated Recalculations and Results Storage 195. Example: Cost Estimation with Uncertainty and Event Risks Using Excel/VBA 196. Using Add-ins to Implement Risk and Simulation Models 196. Benefits of Add-ins 19 All of my Add-ins for Outlook 2016 are inactive with the message not loaded. Certificate of signed and load at startup COM Add-in is not in trusted source list. These add-ins are the Skype Meeting, Exchange, OneNote, Outlook Social connector. All Microsoft Add-ins

Excel Conditional Formatting - Highlight Cells RulesMerge_Files_Move_Copy | Professor Excel | Professor Excel

I'm an advanced VBA developer with formal instruction from London City University. I have 10 years' experience writing custom macros and add-ins for Excel and PowerPoint across a range of industries -- from bond price calculators to railroad design tools. My code is always rigorously tested, well documented and robust VBA: Visual Basic for Applications is a Macro language available in all MS Office Tools. VB.NET is a one of the .NET programming language from Microsoft. We can develop COM Add-ins for MS Office using VB.NET or C#.NET Tools/Add-ins menu forces Excel to open that add-in workbook. All open workbooks, including add-in workbooks (as well as lots of other things that aren't workbooks) appear in the Tools/References list so that you can use them if you like. > Visual Basic For applications > Microsoft Excel 10.0 Object library > OLE Automatio