Would it matter where the variable is defined?

i.e.) ThisOutlookSession vs. your own module (not class)

The declaration would be something like this:

Global CurrentSession As ADODB.Connection

A true global will go out of scope just before Application_Quit fires.
If it's initialized during the life of an Outlook session it should
retain values as long as that session is running.

"Jiho Han" wrote in message
.com...

I have a global variable in my macro project, which gets set by a
macro function if it is Nothing. Depending on this variable, a login
form is shown for the user to login, etc.

When does the global variable get cleaned up? When I run the macro
subsequently, sometimes the variable is still intact, and sometimes,
it's not, so it gets recreated.

Should the macro not depend on any existing state when it runs, so
that each run of the macro is an atomic transaction? If so, what is
a good place to store a session (current outlook session, until the
outlok closes) level information?

Thanks

Jiho Han
Senior Software Engineer
Infinity Info Systems
The Sales Technology Experts
Tel: 212.563.4400 x216
Fax: 212.760.0540

www.infinityinfo.com