Link to home
Start Free TrialLog in
Avatar of bill201
bill201

asked on

rename a file name with vba access 2016

hi

how can i rename a file name with vba access 2016 ?

thanks
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

in VBA, use the NAME commend
Avatar of bill201

ASKER

i tried but i get this error message

run time error 75
path/file access error
What is your code?

Does the Destination Folder already exist if not
use mkDir
Avatar of bill201

ASKER

Now it's work thanks alot