Convert Numbers into English text (521 to Five hundreds twenty one), this one called (SpellNumber) I found online.
And (Num2ArText) that will do the same but in Arabic language , (as 500 to

A simple way to help Excel developers showing the progress of a long operation, what Excel lacks.
What you need to do is copy the form (Frm7) and use the module (mMain) in (XLPrgBar) file into

The first Excel functions-only calendar.
I created it as a sample for my students back in 2006 to show them how we can do monthly calendar using functions only, then I decided to share it

A formula trick to search for an item in a list and get 2nd, 3rd, 4th, 5th and 6th item occurance found.
VLOOKUP (also MATCH and HLOOKUP) only gives you the first occurance
This formula uses

Read any MySQL query into Excel table + VBA Code
This uses VBMySQLDirect application to read data from MySQL database into Excel spreadsheet
To run this you just need to install this app

Since LEGO is a huge part of my life, I got a lot of time to spend with Bricklink.com, and if you do, you will notice that most of the time, your cart

Just like PowerPivot, TaShee, Lets you manage your SQL tables in Microsoft Excel
After you connect to a database in

Browse files and folders inside Excel sheet, a simple tool to help you view files and folders, this was a request from one of my VBA Excel friends.
Code is visible and you can adjust it in any

Excel macro to send emails to multiple email addresses, once you have list of email addresses, names, subjects and bodies in the list, click (Send All) to send emails to all these