View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
skusey skusey is offline
external usenet poster
 
Posts: 2
Default 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.