VBE property on Excel Application object

[Henrik]

Hello,
I have been trying to use the VBE property on the Excel object in order to
try to use and modify VBA-projects in excel files. For example to remove
missing references. I know I can do this through VBA-code in for example a
template or add-in. But I would like to do it straight from automation
through an instance of an Excel-object.

Excel exposes the VBE property on the Application object, but whenever you
try to use it, Excel only says it hasn't been loaded into the runtime, or
something similar. And I don't get what I'm doint wrong. The Excel-online
help doesn't say that this property should be unavailable for automation, and
if so, why should then Microsoft expose it at all if it never gets loaded?

Any help is very much appreaciated. I'm stuck on this one...

 

[Cindy M.]

Hi Henrik,

I have been trying to use the VBE property on the Excel object in order to
try to use and modify VBA-projects in excel files. For example to remove
missing references. I know I can do this through VBA-code in for example a
template or add-in. But I would like to do it straight from automation
through an instance of an Excel-object.

Excel exposes the VBE property on the Application object, but whenever you
try to use it, Excel only says it hasn't been loaded into the runtime, or
something similar. And I don't get what I'm doint wrong. The Excel-online
help doesn't say that this property should be unavailable for automation, and
if so, why should then Microsoft expose it at all if it never gets loaded?

Any help is very much appreaciated. I'm stuck on this one...

What's the EXACT message you're seeing?

Which version of Excel?

Which programming language are you working with?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail