Archive for the ‘Add-ins’ Category.
This is one of two approaches inspired by Dick Kusleika’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/).
I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...]
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. [...]
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 [...]
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 [...]
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 [...]
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 [...]
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. [...]
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 [...]
