[plt-scheme] Anyone competent in VB? MzCom & Excel question.

From: Roderick McGuire (mcguire at telerama.com)
Date: Fri Mar 26 19:21:25 EST 2004

Anton van Straaten wrote:

> I can't really answer this, but you might take a look at the Excel VB help,
> where there's a topic entitled "Using Events with the Application Object".
> It looks to me as though events may not be processed unless you follow the
> instructions in that topic.

The page you mentioned, which can be found by asking the Answer Wizard 
"Using Events with the Application Object", seems to suggest that I 
should include in my "initilize" Sub the line:

  Set MzCom.App = Application

However I tried this and got the error:

   Run-time error '438': Object doesn't support this property or method

This might mean that when MzCom is first run, and "publishes" its 
definition, it doesn't define an App property which means there is no 
way to hook it into the current application and catch events.

On the other hand I am probably completly confused.

Posted on the users mailing list.