easy question...

[martin_b]

Hi everybody,

I have an Excel sheet with a long list of filenames in column A (filenames include full pathname and all files are .xls files).

I want column B to show the info in cell C3 of Sheet 1 of each .xls file listed in Column A.

I want to do this either with a macro or just a formula in the cells.

The filenames are themselves the result of a macro and so they will change everyday.

Can anybody help me?

Thanks!
Martin.