Category

Archive for the 'Addins' Category

Free VBA code library!!!

( Addins and Downloads and .Net )

Right that should get a few people here!
XL Dennis has made public the first version of his code librarian - “.NET Co Library”.
I’ve done a bit of testing for this addin and can personally vouch for how useful it is - keep all you VBA code in one place - copy the .mdb and […]

Data Mining + Excel 2007

( Addins and Downloads and MS )

I don’t really know anything about Analysis Services, but MS have just pushed out some addins for leverageing this part of SQL2005 from Excel 2007 - Thought this might be useful to some folks (I’m thinking of Will!)

M.I.E Colour Pallet

( General and Addins and Downloads )

Looking at the new colour themes in Excel 12 reminded me of a tool I put together a while ago. It’s a colour pallet type tool which lets you build a set of colours in the same range - it’s useful for designing report and the like. Anyway here it is - the help tells […]

Click to install Addin

( General and Addins )

The following code will install an addin to the users local addins folder. There are two constants that need to be changed, well only one really if your installing a .xla. You will also need to modify the call to "Addcustommenu" which appears twice - make a call to your menu/entry points code.
The code actually [...]

XLL update

( General and Addins )

David Gainer was kind enough to answer the mulit thread .xll question
Excel 97 does not support multi-threading. I can see what I wrote was confusing. What I meant was that if you had some XLLs that you have been using for some versions that you want to participate in mult-threaded calc, you can recompile them [...]

Differences between these two types of Add-ins.

( General and Addins )

http://support.microsoft.com/default.aspx?scid=kb;en-us;291392
this is for me really. :-)

2 xll type links

( General and Addins )

XL dennis posted these links over at Dave Gainer Blog, useful, I must read PED also.
http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178474

Not hum Drum!

( Addins )

This is quite cool some kind of drum machine build in excel! Although it does use a .dll, still cool all, the same!