Check if the Object is Empty/Null

[manojith1984]

Hi Ankur ,

Code:

Set Object = CreateObject("Excel.Application")
If IsNull(Object) = False Then
   Msgbox "Pass"
Else
   Msgbox "Fail"
End If

Set Object = Nothing
If IsNull(Object) = True Then
   Msgbox "Pass"
Else
   Msgbox "Fail"
End If

In this code i need to check if the Object is "Null/Empty" after setting the Object to Nothing.

But this code does not provide what is expected. Could you help me out in this regards.