check if variable is set

[Question Boy]

how can I validate if a variable is set in my code?

set olApp = ....

How can i check that this line ran properly and actually set the variable?

IsNull, IsEmpty,Ismissing,... what should I use in this case?

QB

 

[dymondjack]

IsEmpty(), I believe.

IsMissing is only for arguments and I'm pretty sure IsNull doesn't work in
this case


--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain

 

[John W. Vinson]

how can I validate if a variable is set in my code?

set olApp = ....

How can i check that this line ran properly and actually set the variable?

IsNull, IsEmpty,Ismissing,... what should I use in this case?

QB

Try

Is Nothing

 

[Marshall Barton]

how can I validate if a variable is set in my code?

set olApp = ....

How can i check that this line ran properly and actually set the variable?

IsNull, IsEmpty,Ismissing,... what should I use in this case?

Try:
olApp Is Nothing