i got 2 files with me..
"Compile" and "822"

is there anyway for VBA to search for "822" in the PC and copy the data into "Compile" without the user manually opening the file?