Copy, Rename and validate multiple excel files

Hi All, Been scratching around for the last 5 days to find something that works for multiple files. Many a late night/early hours of the morning unsuccessfully piecing together/coding to get a result.
Thanks in advance.

The following code is from get-digital-help.com/copyrename-a-file-excel-vba written by Oscar
I'd really like each row to look at the source path, source file name, destination path and destination file:

For each row:
Column A list the source path
Column B lists the source file name
Column C lists to destination path
Column D lists the new file name

Column E writes "Success" or "Fail" validation.
- if file name already exists in destination, then "Fail"
- If source file doesn't exist, then "Fail"


Nice to have/completely optional!!!
Check if source file column A&B exists, = True or False in column F. Where True, then proceed with copy and rename.
If destination file already exist, the fail and column F = duplicate

Please Login or Register  to view this content.

Hi Bart101

Welcome to our Forum...

Please take a moment to read our forum rules...here
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button
We can only assist once this has been done…Also, see Top yellow banner about uploading a sample file showing expected result...

As explained by Sintek, code is much easier to read if contained in code tags - as can be seen in my reply below
I have not used your code preferring to start from scratch

Run this first to see if I have understood the logic of your data
Refer to image below and let me know what differs in your data if you encounter a problem

Please Login or Register  to view this content.

See result of Debug.Print in VBA immediate window (made visible with View \ Immediate Window)

If the first test works out, then run this

Please Login or Register  to view this content.

Hi Kev, thanks for the fast response.
Ran the test and seemed to produce the required logic.
Ran the second one and produced a compile error with no validation comments.

First time using these type of forums.

In the mean time, I'd received a response/solution from someone else in another forum.
Done some extensive testing and tweaking with the developer which works really well.
Are you interested or am I allowed to post a link to the solution in the other forum to ensure credit or recognition is provided to the correct person?

You could read the forum rules - you agreed to them when you signed up and have already broken 2 of them in your first thread Links of crossposting in other forum should be given and the other forum would expect the same courtesy

This thread may of benefit to future users, so post your solution with link to the crossposted thread
Glad you have a solution