How to check type of Object in VB 6 ? - I do not want to use 'TypeOf' method

vb6
Avinash picture Avinash · Sep 22, 2010 · Viewed 33.1k times · Source

How to check type of object in VB 6.0 we have to modify existing code to use 'typeof' method, Is there any method like moving cursor over object variable or like quick watch where I can see its type.

I know following method but I do not want to use it -

Set fs = New Scripting.FileSystemObject 

If TypeOf fs Is Scripting.FileSystemObject Then 
  Debug.Print "Is a FileSystemObject" 
End If

Answer

Jay Riggs picture Jay Riggs · Sep 22, 2010

Try the TypeName Function.

In your example if you enter TypeName(fs) in the Immediate Window you would get back "FileSystemObject"

Related questions

Does VBA have Dictionary Structure?

Does VBA have dictionary structure? Like key<>value array?

Read More
VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More
How do I resolve "Run-time error '429': ActiveX component can't create object"?

My company has a VB6 application using Crystal Reports 7 which a client has asked to be installed on Windows 7 32 bit. It is currently installed on Windows XP 32bit SP2 machines at the client. Connection to the DB is done via …

Read More