Excel automation isn’t just macros anymore.

We're one of the leading tech book publishers in the UK. We have published 7k+ books, videos, articles, and tutorials. We're one of the leading tech book publishers in the UK. We have published 7k+ ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

Artificial Intelligence (AI) tools are reshaping the landscape of software development, particularly in the realm of generating Visual Basic for Applications (VBA) code. These innovative solutions are ...

Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...

VBA targets to create the unlimited data processing ability for Excel by supporting programming. The issue is how well the target is achieved. As a script tool supporting programming ability, VBA is, ...

Microsoft announced today that it will start deprecating VBScript in the second half of 2024 by making it an on-demand feature until it's completely removed. Features on Demand (FODs) are optional ...

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

Hamza is a certified Technical Support Engineer. The “Compile error in hidden module” error occurs when you open a VBA project in Microsoft Excel. It occurs when ...