VBA Plug allows automation via the command line.
vbaplug.exe ["input" ["outputdir"]] [/A | /E | /M:"macro.pam"]
input
Specify an Office file to read.
If input specifies an Office application name, the program will connect to this application instead of reading a disk file. Valid Office application names are ACCESS, EXCEL, POWERPOINT, VISIO, WORD.
outputdir
Specify an output directory. If no directory is specified, a temporary directory will be created.
The switches /A /E /M are optional and alternative to each other. If you don't specify any of them, VBA Plug waits for user input instead of proceeding automatically.
/A
Export and analyze. Export the VBA projects and run Project Analyzer. Includes all referenced VBA projects.
/E
The same as /A but export only. Do not run Project Analyzer.
/M:"macro.pam"
Export and run macro. Export the VBA projects and run a Project Analyzer macro file. The exported VBA project or project group name is passed as parameter %1 to the macro. You can start your macro.pam file like this:
Analyze "%1"
vbaplug.exe "C:\My Documents\Sales.mdb" /A
Exports the VBA code in Sales.mdb to a temporary directory and runs Project Analyzer to analyze it.
vbaplug.exe "C:\My Documents\Customers.xls" /E
Exports the VBA code in Sales.mdb to a temporary directory and stops.
vbaplug.exe "C:\My Documents\Budget.pps" "C:\My Documents\BudgetVBA"
Sets the input file to Budget.pps and the output directory to BudgetVBA. Does not start the export, however, but stays waiting for user input.
vbaplug.exe WORD /M:"c:\mymacro.pam"
Connects to Word (which must be running already), exports all VBA projects in it and executes mymacro.pam in Project Analyzer.
©Aivosto Oy - Project Analyzer Help Contents