Need help with copying files based on conditions

[cmill02s]

Hello,

I am new to the forums and I have been hit a roadblock for an excel program I am working on for my job. Daily, we have to copy contents of a dropbox folder and move them to a shared network drive. We would like to automate this process. The program itself will likely be ran several times a day so it's important that it meets certain conditions before copying the files.

The code from this site is helpful but it automatically overwrites the files:

http://www.rondebruin.nl/win/s3/win026.htm

I've tried to do research on posts here but none really apply to my needs. With that said, here is what I would like the macro to do:

1. Pull a list of the files names for a specified folder and compare them to the list of files and attributes on our shared network drive. (If there is a better solution to this please feel free to recommend an alternative)
2. I would like to then copy the files from the dropbox folder if they do not already exist. If they do exist and it was created today, I would like to skip the copying process. If it was NOT created today I would like for the vba to add a timestamp to the filename as such "filenameYYYYMMDD.pdf" and then proceed with the copying process.
3. If possible if I could add a status bar of the copying process and generate a popup notification once the copying is complete.

Thank you all so much in advance for helping me look for a solution.