View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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