User-defined type not defined error declaring FSO

[Ark68]

I am trying to delete a folder using this code...

Dim FSO As New FileSystemObject
Set FSO = CreateObject("scripting.filesystemobject")
FSO.deletefolder dpath

But I am getting an error ("User-defined type not defined") when it encounters the declaration statement for FSO.
Thoughts?

 

[Fluff]

Have you set a reference to the scripting run time library?

 

[Ark68]

Hi Fluff, I'm sorry, but I don't understand what you mean?

 

[Fluff]

You need to goto Tools, References, then scroll down & tick the Microsoft Scripting Runtime option.

 

[Ark68]

Ahhh ...ok.
I think that worked.

 

[Fluff]

It shouldn't matter.
However you could try using late binding like

Dim FSO As Object
Set FSO = CreateObject("scripting.filesystemobject")
FSO.deletefolder dpath

 

[Ark68]

Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.