VBA versus XLM

Before version 5, Excel used a powerful (but very cryptic) macro language called XLM. Later versions of Excel (including Excel 2007) still execute XLM macros, but the capability to record macros in XLM was removed beginning with Excel 97. As a developer, you should be aware of XLM (in case you ever encounter macros written in that system), but you should use VBA for your development work.

Note Don't confuse the XLM macro language with extensible Markup Language (XML). Although these terms share the same letters, they have nothing in common. XML is a storage format for structured data. The Office 2007 applications use XML as their default file format.



Was this article helpful?

0 0

Post a comment