If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

JavaScript isn't replacing Office macros anytime soon, but the Office Web apps (and the SharePoint-based enterprise equivalents) are improving regularly. For users that means simple but useful ...

In the well-established Office Ready-Fire-Aim tradition, Microsoft adds two new “features” that beg to be abused. Details appeared at Build, and the bad guys already have their keyboards primed.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

Enabling JavaScript should make Excel more powerful, but increasing access points makes it even more of a web security nightmare than it already is.

How to Start a Macro When Opening an Excel Spreadsheet. Excel macros use Visual Basic code to perform functions unavailable through the program's graphical controls. For example, macros can ...

How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true ...