There will always be overlap in what a scope allows. Personally, I use StackOverflowStack Overflow just for questions that are purely programming based, that will be compiled into a program. Batch files are just lines of commands, freely editable, and user accessible. You do not need to be a professional programmer to do Batchbatch programming.
I feel that PowershellPowerShell fits in the same boat. VBA programming could fit in both; it's a powerful language that can turn your Office document into a program, but it's also simple enough that the average user has access to it and may fiddle with it.
From the StackoverflowStack Overflow Help Center:
Ask about...
Specific programming problems Software algorithms **Coding techniques** **Software development tools**
Don't ask about...
**Questions you haven't tried to find an answer for (show your work!)** Product or service recommendations or comparisons Requests for lists of things, polls, opinions, discussions, etc. **Anything not directly related to writing computer programs**
So, I would say those questions can be here or there. Also, on the question you linked to, a modmoderator already weighed in saying it's OK.