in vba, how do u

using vba. if i have a file thatis already open, how do you open another file (using vba code, and selecting the file from the open file application) and transfer the data of the file you open to the file that was already open before? either by moving the worksheet or copying and pasting the data.

thanks