delete folder

[Guest]

I'm using kill function to delete files. I'm having trouble using this to
delete folders. Can I use this to delete folders or is there a better way?

Thanks,
Chad

 

[Guest]

The folder must be empty first

Sub getrid()
On Error Resume Next
RmDir "C:\Myfolder\"
On Error GoTo 0
End Sub

Mike

 

[Guest]

Perfect, thanks!!

The folder must be empty first

Sub getrid()
On Error Resume Next
RmDir "C:\Myfolder\"
On Error GoTo 0
End Sub

Mike

 

[Ron de Bruin]

See also
http://www.rondebruin.nl/folder.htm#Delete

 

[Chip Pearson]

Note that RmDir requires that the folder be empty and then the deletion of
the folder is total and unrecoverable. I would recommend you use the Recycle
Bin which allows you to delete folders that are not empty and puts them in
the recycle bin so they can be restored, just in case. See
www.cpearson.com/Excel/Recycle.htm for example code.