| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel opening new copy of application for each file | Excel Discussion (Misc queries) | |||
| Copy File Automatically on Opening It | Excel Discussion (Misc queries) | |||
| Copy File without opening | Excel Programming | |||
| Copy data from diff workbooks but without opening sheets | Excel Programming | |||
| Copy a Sheet without physically opening the file | Excel Programming | |||
![new_to_vba[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
