Browse by Tags

UDFs and Moving Add-in Files

I don’t use user defined functions in add-ins all that often, but I happen to have a particular add-in with one UDF. And I happened to have recently moved that add-in. And all my links happen to be broken. Fortunately, Jan Karel has an exhaustive write-up on how to fix and prevent this problem. [...] Read More...

Published Tue, Dec 12 2008 3:51 PM by Daily Dose of Excel

Filed under: Add-ins, User Defined Functions

Multiple Add-ins

I'm creating several add-ins that will all use the same top-level menu item. The add-ins will be installed as needed. So someone may have just one and someone else may have half a dozen. The right answer, I think, is to have one controlling add-in that handles the menus (and not much [...] Read More...

Published Tue, Jul 07 2008 5:08 PM by Daily Dose of Excel

Filed under: CommandBars, Add-ins

Determine Which COM Add-ins Are Installed

The COM Add-in (Component Object Model) toolbar button is not on any toolbars by default. You have to add it and then click on it to get to the COM Add-in dialog. First, right click in a blank area around the toolbars and choose Customize Go to Tools on the left and COM Addins [...] Read More...

Published Wed, Jul 07 2008 5:01 PM by Daily Dose of Excel

Filed under: Add-ins, Toolbars

Fixing Links To UDF’s in Addins

Hi All, Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s work as expected. You get into trouble [...] Read More...

Published Mon, Jun 06 2008 1:45 PM by Daily Dose of Excel

Filed under: VBA, MVP, Downloads, Add-ins, User Defined Functions

Two popular tools updated.

Hi All, As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads: Name Manager (which I created together with Charles Williams, www.decisionmodels.com): Most important change: the unused names filter now includes objects in its search, as well as VBA code. It [...] Read More...

Published Fri, Mar 03 2008 3:03 PM by Daily Dose of Excel

Filed under: Links, MVP, Downloads, Add-ins, Miscellany, Names, Finding Data

Bogus Compile Errors

Hi all, Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day. Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could reproduce. [...] Read More...

Published Mon, Feb 02 2008 1:08 PM by Daily Dose of Excel

Filed under: MVP, Downloads, Add-ins, Miscellany

ExcelRefTool; A New Formula Auditing Tool

Hi, A while ago I requested beta testers for a new utility, now called "ExcelRefTool". Thanks to my beta testers, the tool is now mature enough to be exposed to the general public. Have a look here, download the demo if you like and give it a spin. And thanks again, to everyone who took the trouble of beta [...]

Published Mon, Dec 12 2007 8:53 AM by Daily Dose of Excel

Filed under: General, MVP, Downloads, Formulas, COM Addins, Add-ins

Syndication

Recent Posts

Tags

News

Archives