Possible to read a specific cell from many excel files automatically?

Hello everybody

Is there anyway to read a specific cell from many excel files automatically and add them to a new workbook?

I tried to link that specific cell to a new workbook manually but now I have a problem:
If I change the name of any workbook that is linked to the new workbook, Excel can't update the new file name

Yes, it's possible to do without linking, using VBA. There are a few questions first:
1. Are the Excel files already open or are they closed?
2. Is there a specific Sheet Name?
3. If the files are closed, is there a list of files, or is there a unique way to identify the files (such as ABC01.xls, ABC02.xls, etc.)?
4. Where in the new workbook do the copied cells go?

Lewis

Hi,

Try the attached file. It is a first attempt to do what you want. Please let me know what changes you need.

When you test the file make sure you:
a. Purposely test a file that has no data in C4 and/or D4
b. Purposely test a file that doesn't exist.
c. Purposely test a file that is already open.

Assumptions:
a. Data is in the first sheet of the data file.
b. Company name is in Cell 'C4' and price is in Cell 'D4'.
c. File Names in sheet 'PriceData' must be contiguous. Use 'None' as a place holder.
d. File type is .xls, .xlsx. or .xlsm

Lewis

@LJMetzger: Thank you Though your code looks complex, I could write my code finally :D
@mc84excel: Thank you, will check your code too