Renaming a windows folder

[John Baker]

I am looking for a method or code to rename folders in windows directly
using VBA or some other method while in Access.

Any help greatly appreciated.

John B

 

[Brendan Reynolds]

Public Sub CreateAndRenameFolder()

On Error Resume Next

'careful with this - make sure
'you don't have folders with
'these names that you don't
'want to mess with.
RmDir "C:\TestFolder"
RmDir "C:\RenamedFolder"

On Error GoTo 0
MkDir "C:\TestFolder"
Name "C:\TestFolder" As "C:\RenamedFolder"

End Sub

 

[John Baker]

Thanks for your reply Brendan. I used the "Name as" code and it worked
beautifully.

Cheers
John.