external excel data macro

Victtor

Board Regular
Joined
Jan 4, 2007
Messages
165
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...
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,118,165
Messages
5,570,581
Members
412,327
Latest member
KLichter
Top