no grey

To paraphrase Johnny Nash, "I can see clearly now the grey is gone."  The grey in question being the mysterious greyed out ribbon even when a workbook is open in Excel.

Published in Ian's Excel Addin

What's new on the menu?  Quite a bit actually, with the new Excel ribbon based interface for a start.

The old menu driven interface for the addin has been replaced with the user friendly Office style ribbon interface.


The new ribbon interface for Ian's Excel Addin

Published in Ian's Excel Addin

This function is used to convert a numerical value into its equivalent textual representation, e.g. 123 becomes One Hundred and Twenty Three.  Used in the format of =textamount(value[,"MajorCurrency"][,"MinorCurrency"]) where:

Published in Ian's Excel Addin

Items under the Special Characters menu are used to insert special characters.

Published in Ian's Excel Addin

Items under the Numeric Functions menu are used to manipulate values or formulae.

Published in Ian's Excel Addin

Items under the Text Functions menu are used to manipulate text.

Published in Ian's Excel Addin

March 2015 update:  The menu style interface has been superseded by the Office style ribbon interface.  See this article for more information.

While earlier versions of Microsoft Excel allowed a developer to add their own menu to the menu bar relatively easily, the newer versions have thrown a bit of a spanner in the works when it comes to creating custom menus.  It does not surprise me then that users often ask "where do I find Ian's Excel Addin after I have installed it?  Fortunately, the answer to that is relatively simple.

Published in Ian's Excel Addin

This is the online user manual for Ian's Excel Addin.  This will be a work in progress for the foreseeable future.

Published in Ian's Excel Addin

Over the years working as a Quantity Surveyor, I discovered that Microsoft Excel, while a wonderful tool, lacked certain functions.  In order to overcome these shortcomings, I developed custom procedures and functions to enhance my Excel experience and productivity.  Instead of keeping these tools to myself, I have decided to share them with anyone who is interested in trying them out.  Your feedback on the addin will be appreciated and will assist in the further development of this product.

Published in Home

See this amazing video of how the WinQS ASCII Import function can save you time.  The entire WinQS Standard Library was exported from WinQS then imported into Excel and formatted in only 72 seconds!

There is no trickery involved in this video, it is a real time screen capture video.

Imagine how much time you can save using this import method.  Simply register as a user and then download your copy of Ian's Excel Addin right away.

Published in Home
Page 1 of 2

Vulnerability Scanner

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.
More information Ok