Hi there

I have written a program which is shareware and which could solve the
problem. You can define names in every single workbook and
the program collects the data over the names in one many workbooks and
creates a list in a new workbook. Then you could record a macro and directly
copy/paste the code in
the program so it will be excecuted every time you start the report. The
program is in German but I can help you with that. Unfortunately the program
is not free of charge but has a 30 day evaluation period.

Download-Link: http://www.excelspezialist.ch/index....v=400&text=430

Kind regards,

Alex
------------------------------------
Excel-Spezialist
www.excelspezialist.ch
------------------------------------


"Jacob" schrieb im Newsbeitrag
...
I am getting Excel file names from a user, and I want to take the array of
file names and get the same range of cells on each file using the file
name.
The files are on a NAS. I can do this in Excel by opening both file and in
the cells I want hitting "=" then clicking on the file and the cells I
want.
I would like to automate this, but when I parse the string to the right
syntax and it just puts it in the cell as a string. I try the .value and
.formula but that returns an type mismatch error.

I sorry for the long message, I am new at this