I have 3 database. Database1 (C is my personal database. Database2 (D is a worldwide shared database which is very slow. and lastly Database3 (J which is a mirror of "D:" for viewing purposes only (cannot copy nor paste in this database). To copy a file from D: to C: what I normally do is go to J: first ,as this drive is 100x faster than D:, to search the files I want to copy. Once I find my target files, I copy the path from J then open that path in D: Drive (e.g., Copy J:\Gelatine\Sugar\Baby.xls and paste in D: Drive as D:\Gelatine\Sugar\Baby.xls) which takes several minutes to load. Once D: Drive is open, I can now copy the file from D to C. (take note J drive is for viewing purposes only.).

What I want to achieve is to make a UI/Userform with 2 textbox and 1 button. Textbox1 is where the user will put the path from J: and textbox2 is the path where the user wants to save the target files from J. Once the button is pressed, this will automatically save the files from J/D to C.

Is this possible?

I am not really sure what vba codes to use.

Please help. Thanks.

Thanks.