Having few files with different extensions (pdf, doc etc) in a folder. Below sequence to be achieved.
Earlier I have received support from arnelgp for moving the files without replacing. However, I realised that the renaming file has to be done which I am struggling now.
Please assist. Hope I stated the problem clearly.
https://www.access-programmers.co.u...-replace-and-append-files.315616/post-1741337
- rename all the files in the source folder. as Me.textName with a random suffix for multiple files but all names should start with Me.textName without affecting the file type (random suffix like alphanumeric or timestamp whatever)
- Check subfolder with name Me.txtName exists under "c:\\ToFolder". If not create a subfolder with name Me.txtName under "c:\\ToFolder"
- Then move all files to the destination folder "c:\\ToFolder\me.txtname\".
- if any of the file names exist, add the file with a series instead of replacing it. The filename should contain Me.txtName as a prefix, suffix doesn't matter may be random alphanumeric or timestamp whatever.
- In summary, have to move all the files from the temporary folder to destination folder "c:\\ToFolder\Me.txtName". rename the file to series if filename already exists.
Earlier I have received support from arnelgp for moving the files without replacing. However, I realised that the renaming file has to be done which I am struggling now.
Please assist. Hope I stated the problem clearly.
https://www.access-programmers.co.u...-replace-and-append-files.315616/post-1741337