It's a 1980s-era format meant to transfer data among Office applications. Both VBA and XLM macros are flagged by Excel's security settings on both Windows and Mac.īut there's an even older file format called SYLK, short for "symbolic link" and with the file extension ".slk". Until 1993 and Excel 5.0, Excel macros were written and stored in a different format called XLM. Microsoft Office macros are today written in Visual Basic for Applications (VBA). To prevent this, macros are disabled by default in all modern versions of Office. In Word, you might create a macro to replace British spellings, such as "colour" and "gaol," with American spellings, such as "color" and "jail." You would just have to press a button in the Word toolbar.īut macros are a bonanza for hackers, who can embed malicious macros in booby-trapped Excel, Word or PowerPoint files.
Macros, familiar to Office power users, are mini-scripts that let you automate repetitive tasks.