Copy newest file in folder to a new folder with new name

I'm trying to look in a folder in which it will have many Excel files and find the newest .xlsx file in that folder and when it finds it I would like to copy that file to a new folder with a new name.

1.Search "source" folder and find the newest Excel file in that source folder,
2.Then copy it into a "destination" folder with a specific name (Weekly Report for Presentation)
3.If Weekly Report for Presentation is already in the destination folder replace it with the newest copy.

The source folder will have many Excel files all with basically the same name except with last part will have a date xx-xx-xx. It can search for the name or for the newest date a file was modified. Maybe it would be better to search for the newest date a file was modified.

The folder path in the code will not be the path of the real files. I would want the macro in a separate Excel file that I can run from any folder/pc.

Thanks for any help in advance!!

Please Login or Register  to view this content.

Sorry I have little knowledge of VB. I tried putting the two codes together by replacing the "open the latest file" with the code I had.
I tried several different ways and I keep getting error at the bottom line.

Please Login or Register  to view this content.

Thanks!! Works perfect!