Ran across this article a while back, bookmarked it for later comment. It's later, I'm commenting.
ArticleLoad and Run VBA Macros Using Straight VBA
Contrary to popular belief, the process doesn't require AutoLISP
Woohoo! This is great, can't wait to see how to do it.
Kick it Up Another Notch
The next kicker is adding a command-line definition directly from our DVB file. Instead of having a LISP file do it, you can combine a LISP statement and the SendCommand to accommodate this option. Anyone familiar with my posts on the newsgroups should know I don't advocate using the SendCommand or mixing programming languages. However, in this case, there's no better solution available unless you do it in ARX or NET. So, here is the LISP statement you would normally place within a LISP file or attach to a toolbar button:
(Defun C:VBAT ()
(vl-vbarun "c:/{your install path}/ Custom_menu.dvb!CreateVBAToolBar"))
OK, how is this not using AutoLISP. This is like saying that if I load and execute an ARX from inside a VBA routine that I can do whatever it is that the ARX does "in VBA without using ARX."