h
For some reason, i have to write a macro to copy some ranges of two files with the same name but in different directories.
then paste them to target file. The process is quite simple but in Excel, open two files with the same name even from different directories is not allowed. Therefore, i figured out a compromised way to do is: open file1, copy and paste i
to target file; close file1. Then ask user to open file2; then press a command button to do the thing of copy an
paste it to the third file. Of course, it works fine but I still wanna know is there any better solution to do with this problem

An ideal solution for me is user open two files concurrently then press a button that copy and paste to the target file
Thank you very much