When should you use VBA, and when should you not?

Use VBA for interactive desktop automation, custom dialogs, and manipulating Excel's own objects — formatting, printing, sheet management.

Do not use it for importing and reshaping data; Power Query is refreshable, maintainable, and avoids macro-enabled files that many IT policies block.

For anything that must run in Excel on the web or a cloud workflow, Office Scripts is the supported path — VBA does not run there.