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

I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the

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

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

I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the