excel plugin

[2cool4u]

Does anyone know how to write an excel plugin, like DigDB? I have a formula that wuold be very useful for many people but a plugin would make it even easier.

Thanks

 

[TSDible]

I know this is a late reply.

You can write the formula as a function in a normal macro in a blank sheet. Then, you just save it as an excel add-in (*.xla). I've worked on one here complete with menus and everything.

Then, users just have to install that add-in and they will have the custom formulas available.