*Excel4Macro

Recently I came across Excel4Macro. Now for those of you who have never heard about this might be wondering… What this is?? To give you a brief history of macros: In versions prior to Excel Version 5 excel had a macro language other than VBA. VBA was introduced in Excel Version 5 and the previous language has continued to be supported for compatibility. Most people call it the Excel 4 macro language.

For instance it can be used to retrieve colour index of a cell without writing a regular macro. Read the below two articles to know exactly how this can be done:

http://www.ozgrid.com/forum/showthread.php?t=82173 (Read the #4 post)
http://www.sulprobil.com/html/get_cell.html

Now it is quite interesting to see how this language works. Here another very good example of this language; it retrieves values from closed excel files.
http://www.j-walk.com/ss/excel/tips/tip82.htm

I am sure you would truly appreciate this old but powerful language.

-Karthik