The short answer is no — you can’t run Excel VBA macros directly from Node.js, and libraries like xlsx won’t help with that either.
The main reason? Two different systems/mechanics
VBA is Excel’s territory: Macros are interpreted and executed by Excel itself. There’s no standalone VBA runtime you can tap into from Node.js.
Node.js lives outside that world: It can read and write Excel files at the data level, but it can’t talk to Excel as a running application or trigger internal macro execution.
An npm package like 'xlsx' doesn’t bridge that gap: they are great for manipulating spreadsheets — cells, styles, structure — and can even preserve embedded VBA code (the raw VBA code, should it exist), but they don’t run it. That part stays inert unless Excel opens the file and runs it, which cannot be triggered by node.js.
You would need something that can actually launch Excel, like PowerShell. I hope that helps.