Accessing the VBA project object model
 

http://www.cpearson.com/excel/vbe.htm

discusses working with the VBE/VBA with code. You would establish an
application.object, Workbook object and from that you can get to the VBE
objects.

Regards,
Tom Ogilvy



"Frank" wrote in message
...
How can one access VBA projects from outside of Excel,
i.e. from an external program.
I once saw an article describing the object model for VBA
itself as well as giving directions on how best to do it.
Can someone help with a link or information about this.

Regards,

Frank