Run external .bas modules in VBA
Posted on 2006-05-09
What I need to do is run the Main routine of a .bas module stored in file x:\path\somename.bas
I have a program that creates data conversion routines for me in vbasic and saves them as .bas files. There are hundreds of them.
Each one is a stand-alone .bas module and the primary routine name to be executed is Main with no parameters.
If I import the routine into my VBA (Access), I have no problem running it, but my goal is to automate the running of selected ones of them driven by a query from an Access table. Doing these by hand would take a very long time and would be error prone.
My thought is to use the Access VBA to drive which routines run and in what order (via a query which supplies the filename). The routine would invoke each of the external routines, one after the other until the list was complete.
Using Shell & OpenProcess so I could monitor the progress would be ideal, but I'm afraid I have no idea what the parms would be to Shell.