Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Geeting Sheet background from Excel object model Sheela Excel Discussion (Misc queries) 3 September 4th 08 01:40 PM
Error accessing external object property XVALUES sergio Excel Discussion (Misc queries) 2 February 7th 07 04:47 PM
Accessing current project path Dhonan Excel Discussion (Misc queries) 0 August 15th 06 10:03 PM
VBA: Where to find Excel Object model? N. Foldager Excel Discussion (Misc queries) 13 February 6th 05 06:43 PM
"Excel.Application" Object Model Shaker Charts and Charting in Excel 2 January 9th 05 10:24 AM


All times are GMT +1. The time now is 12:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"