Import data from other Excel file if file ends with "[directory][filename].xls"
 

Hi everyone, need some help (obviously)....

I have a folder with many different types of Excel files. There are
many different Excel files with many different types of filenames
however, there are a number of Excel files within the folder that end
with "Rescan Errors.xls" and I want Excel to import the data from the
"Rescan Errors.xls" files into a "DCC MI.xls" file.

I want data from cell "B4" in the "Rescan Errors" file to be dropped
into cell A1 in the "DCC MI" file.

Obviously, I have no idea on how to do this and would like some help if
poss.

Many thanks in advance for your help.

Import data from other Excel file if file ends with "[directory][filename].xls"
 

Hi skusey

Try this
http://www.rondebruin.nl/copy3.htm#range2


--
Regards Ron de Bruin
http://www.rondebruin.nl



"skusey" wrote in message oups.com...
Hi everyone, need some help (obviously)....

I have a folder with many different types of Excel files. There are
many different Excel files with many different types of filenames
however, there are a number of Excel files within the folder that end
with "Rescan Errors.xls" and I want Excel to import the data from the
"Rescan Errors.xls" files into a "DCC MI.xls" file.

I want data from cell "B4" in the "Rescan Errors" file to be dropped
into cell A1 in the "DCC MI" file.

Obviously, I have no idea on how to do this and would like some help if
poss.

Many thanks in advance for your help.