Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...

I've been treating Excel like a glorified calculator for most of my life. Sure, formulas made doing more complex calculations easier and automatically updated data, and there are free Excel templates ...

As someone who spent months hand-crafting Visual Basic scripts in Microsoft Office, only to have Microsoft pull the rug out from under me with the release of Office 2008 (they abandoned VB support for ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

How to create a self-signed digital certificate for VBA macros in Office 365 Your email has been sent Macros in Microsoft Office are blocked for security reasons, but ...

On March 19, 2003, Microsoft warned of a flaw in the Windows Script Engine, which executes JScript and Visual Basic scripts on a Windows computer. The scripts can be used to add functionality on a Web ...