If you have shared folder without control of who is a uploading & downloading (copying) file, there a simple solution to it. Through this file a manager you can keep a store of your shared folder.
In this macro i have kept C:\temp as default folder which you can change as per your choice, Run macro & select option either upload & download.
When you select download you will be asked to C:\temp folder & you can select file to be download, select file & after that you will be prompted for destination folder where you want to downalod/copy file. Enter file description if any & you are done.
Similarly, for uploading a file you will be prompted to select a file to be uploaded to default folder, select file & file will be copied/uploaded to a default folder.
Click to Download File
Give Feedback & Recommendation
tag:Excel VBA File Upload & Download Manager / File copy paste from one location to another