Move file

[hendrikbez]

I am trying to move a file to other folder , then rename the file.



The rename file part is working, but I cannot get to move the file to other folder.

Private Sub savetbn_Click()

FileCopy "D:\Users\HBezuidenhout\Documents\Tapes\access\insert.xlsm", "D:\Users\HBezuidenhout\Documents\Tapes\insert.xlsm"

Name "D:\Users\HBezuidenhout\Documents\Tapes\Insert.xlsm" As "D:\Users\HBezuidenhout\Documents\Tapes\" & Format(Date, "yyyy mm dd") & ".xlsm"
                               
End Sub

[June7]

What does 'cannot' mean - error message, wrong result, nothing happens? It works on my laptop.

Should be able to do move and rename with just Name method - original file is deleted. What you are doing is copy and rename - original file is unchanged.

[hendrikbez]

What does 'cannot' mean - error message, wrong result, nothing happens? It works on my laptop.

Should be able to do move and rename with just Name method - original file is deleted. What you are doing is copy and rename - original file is unchanged.

Sorry should have give info there.

Getting run-time error '70"
permision denied

I do have a password to get into the database, I did sine in with it, but still give error.

[June7]

May be running into a security restriction with Windows on a network. I used to be able to programmatically copy file on network at work but then new computers blocked this. Review https://stackoverflow.com/questions/...mission-denied

[hendrikbez]

Got it working, fault at my side, the file was open, and I did not see it.