move file folder

[pedroc74]

It is possible to move a file from one folder to another with the file open?
If so .... I need help using macros but I'm very new at this

[JBeaucaire]

No, typically operating systems "lock" files in use so they cannot be acted on by other actions until the user closes the file.

With the file closed, it is trivial for a macro to move a known file to another location.

With a file open, perhaps "saving" the open file TO the new location would sufficiently break the connection to the old location and allow the newly saved document to now delete the original file still on the hard drive...

[pedroc74]

Hello Jerry

I have an original file that is open, writes to the client's name and the date and run a macro that creates the file "name & date + number" in the "TO DO" folder.
The document is worked by several people and when this is finished we have to put in the "Ready to be Sent" folder.
With a macro to copy the document to the "Ready to be sent" folder and go to the folder "TO DO" and delete the other file my problem is solved.
Never again would my boss nagging me because someone did not do its job well ...