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?

[Jim Thomlinson]

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/arch...ing-workbooks/
--
HTH...

Jim Thomlinson


"new_to_vba" wrote:

>
> 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?
>
>
> --
> new_to_vba
> ------------------------------------------------------------------------
> new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
> View this thread: http://www.excelforum.com/showthread...hreadid=518074
>
>