News

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 ...
When you create a macro, make sure to run and test it a couple of times to ensure that it’s working as expected. Aside from these macros, I also follow these tips to give my spreadsheets a ...
Enabling JavaScript should make Excel more powerful, but increasing access points makes it even more of a web security nightmare than it already is.
Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the reminder Alert only works if the Excel software is open.
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.
Fix Runtime error 7 Out of memory when the Microsoft VBA tries to execute an automated task in Excel by following these suggestions.