VBA - file search
Posted by Mindy on August 23, 2001 10:58 AM
If I open an Excel file (named it: fileA) with macro. The macro is going to look for another 2 excel files and copy the data to the fileA.
Now, my questions:
1. If only file name is given, how should the code to be in VBA to search the window directories?
2. Will it be possible to have a control or form to list the driver and directories?
( I checked the tool bar now which doesn't have driver icon and directory list icon) Any idea of what to do?
Thank you for the help, any suggestion will be real useful, too.