Rename Folder

[Tom]

How can I rename a folder using vba

tia

Tom

 

[Allen Browne]

Try the Name statement.

 

[Tom]

Allen

Could you give an example f the code please

Thanks for your assistance

Tom

 

[Wayne Morgan]

Example, courtesy of the Help file.

Renames a disk file, directory, or folder.
Syntax:
Name oldpathname As newpathname

 

[Tom]

Thanks Wayne

The Access Help file on this pc has not wanting to open hence the request
for code sample.

Tom

 

[Allen Browne]

It's just a matter of:
Name "C:\MyFolder\MySub" As "C:\MyFolder\MyNewName"

 

[Tom]

Thanks Allen - works a treat

Tom

It's just a matter of:
Name "C:\MyFolder\MySub" As "C:\MyFolder\MyNewName"