external excel data macro

[Victtor]

I need to create a file that when I click on a combo button, this macro command will:

1. search in the specified folder
2. open a source file
3. copy the data it needs
4. paste the data into the original file
5. close the source file.

I need to be able to name the file directory on the spreadsheet itself so that multiple users of this file can specify where their own source files are located.

For instance I need to type into cell b3 the following path:


c:\Documents and settings\vhatcher\test folder\

The macro uses this information to look in that particular path to find the source file. Any user can change the info in cell b3 so that it matches their source file path.

Please help if you can...