Solved Problem When Instantiate a Folder Object From Scripting.FileSystemObject

[ADIGA88]

I am trying to instantiate a folder object to list the files inside a specified folder through GetFolder Menod of "Scripting.FileSystemObject" object, and it's returning a string instead of a Folder object!

Attached:
1. a screenshot of the code and its debugging output.
2. a screenshot of the MS Access doc page for Scripting.FileSystemObject object.

The link to MS Access doc:

Folder object

Office VBA reference topic

docs.microsoft.com

The Code I am running that shoud retrun a Folder object:

Option Compare Database
Option Explicit


Dim fs As Object ' File system object
Dim f As Object  ' Folder Object
Dim s As Object  ' For later user

Sub ShowFolderInfo()
    
    Set fs = CreateObject("Scripting.FileSystemObject")
    
    Set f = fs.GetFolder(fs.GetAbsolutePathName("C:\Dell"))
    Debug.Print "VarType fs is " & VarType(fs)
    Debug.Print "VarType f is " & VarType(f)
    Set fs = Nothing
    Set f = Nothing
    
    's = f.DateCreated
    'MsgBox s
End Sub

 

[Gasman]

Mine shows as object in the Locals window?

 

[ADIGA88]

Mine shows as object in the Locals window?

mmmm, I think I understood what happed, Debug.Print "VarType f is " & VarType(f) return the type of the defult property, not the variable type, I didn't think to use the watch windows to verify the type of the object.
Thanks.

 

[Isaac]

mmmm, I think I understood what happed, Debug.Print "VarType f is " & VarType(f) return the type of the defult property, not the variable type, I didn't think to use the watch windows to verify the type of the object.
Thanks.

Yes, "Returns an Integer indicating the subtype of a variable, or the type of an object's default property."

Addition, if you run that same code and instead of VarType, use TypeName(f), you get Folder

TypeName is probably useful a lot more often than VarType is, because TypeName will always only describe the variable itself.

 

[Isaac]

Yes, "Returns an Integer indicating the subtype of a variable, or the type of an object's default property."

Addition, if you run that same code and instead of VarType, use TypeName(f), you get Folder

TypeName is probably useful a lot more often than VarType is, because TypeName will always only describe the variable itself.

For the sake of posterity, I should probably add to this that I found out today that instead of TypeOf, when I switched to Late Binding, I had to use Typename(somevar)="somestring"

Maybe that actually is a good reason to use TypeName sometimes.