Copy Data from File A to File B

have 3 excel files

-File A= Source Data

-File B=Destination file

-File C=File where I have my Macro.



I need to write in File C a macro that copies data from file A and paste it to file B.

Because File A and File B could be anywhere in the hard drive, I’m using the “Application.GetOpenFilename” to ask the for the location and name of File A (source) and File B (destination).

Now that I have the location of each file, which should the right code to make excel copy cell values from file A and paste them to file B?
(I already have the locations in file A and the locations in file B where I want it to copy the data).


I appreciate your help very much.

thanks

I just need a small hint.
For example, How to copy cell B3 from File A into Cell D1 in File B. But the macro is in File C.