Copy data without opening file

[new_to_vba]

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?

 

[Guest]

The PC is a rather large place to look. I would imagine that your user does
not want to wait that long. Try doing a search of your C drive to see just
how long it might take. That being said here is a link to an interesting
discussion on retrieveing data from underlying workbooks...

http://www.dailydoseofexcel.com/arc...s-to-retrieve-data-from-underlying-workbooks/