Copy data without opening file
 

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

Copy data without opening file
 

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