Hi,

I am working on an (excel based, VBA) application today that will be opening
multiple excel.application objects. This opening of multiple excel objects
is essential to the functionality of the application, as I will be execting
multiple adodb calls to a SQL server, and this is not possible from the same
excel instance.

What I want to accomplish is to have the worbooks opened in each of those
excel.application objects have access to a variable in the application
itself.

Do I need to declare such a type in its own class? I tried just declaring
it as public in the declarations section of a standard module in the
application.

Thanks in advance.

Ariel