... in essence seems to me to be production of a executable program and documentation within a single source (document) from which follows that we will often need two tools - one to extract/compile/execute the machine-relevant portion, and one to extract/compile/layout the human-readable portion.

I can't find any Literate programming tools for VBA (yet!).
Anyone else out there looked?