Test if object exists

[johnaregan]

How do you test if an object exists?

 

[dsi]

What type of object? I think that a little more detail is required for an answer.

 

[rajeevnandanmishra]

Hi johnaregan,

You can check this with ISOBJECT() function.
But the problem you might face is that this function returns True even if the variable is set to nothing.

 

[jmarler]

If you are just checking to see if a variable (i.e. a pointer) is set to an object or not, use the is nothing command. For example

If not myObject

is nothing

 then
    '** Do something with the object.
end if

- Jeff Marler B-)

 

[JohnYingling]

If you want to see if the component is registered then

Dim objW as object
Dim lngErr as long
On Error Resume Next
    Set objW = CreateObject("scripting.FileSystemObject")
    lngErr = Err.Number
On error goto 0
if LngErr <> 0 then
    ... object is not registered
End if

http://WWW.VBCompare.Com