renaming files using an access module

[shawnbaker]

Been trying to rename a file using the shell command in VBA

stAppName = "REN u:\ImportExport\bob fred"
Debug.Print stAppName
Call Shell(stAppName, 1)

However I get a file not found error.

The file exists, the drive is mapped, and I can rename it in the cmd window using the above line.

Any altrernitive methods would be good.

 

[PHV]

Straight VBA:
Name "u:\ImportExport\bob" As "u:\ImportExport\fred"

If you insist for the shell:
stAppName = "[!]CMD /C [/!]REN u:\ImportExport\bob fred"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shawnbaker]

DOH. Thanks much.

name is much better.