Creating & deleting file folders

[WangYa]

In my application I have to use a folder temporary (thus called TEMP). After use I like to delete this folder.
Is it possible in Excel VBA to create and delete a file folder?

[Tom Schreiner]

Hi
Which version of office are you using?
Tom

[BabyTiger]

Hi,

You can try using the following:

to create folders:
mkdir "C:temp"

and to delete folders:

rmdir "c:temp"

HTH

[Ivan F Moala]

On 2002-03-26 18:16, BabyTiger wrote:
Hi,

You can try using the following:

to create folders:
mkdir "C:temp"

and to delete folders:

rmdir "c:temp"

HTH

BabyTiger the rmdir won't work if the Dir
has files in them....you can do this though

Sub RemoveDir_WithFiles()
Dim Fs As Object

On Error GoTo DelErr
'CAUTION: Will delete entire Folder NO PROMPT
Set Fs = CreateObject("Scripting.FileSystemObject")
Fs.DeleteFolder "C:mydir", True

Exit Sub
DelErr:
MsgBox Err.Number & vbCr & _
Err.Description
End Sub



Ivan