In column "A" I have about 400 file names with each path, for example:

D:\Folio_02\AL605_02.xls

Each file contains a value named "ATT" and another named "XBB". I need to
get these values in adjoining columns. I've tried every variation of the
following I can think of without success:

A1&"!"&ATT

None have worked. I'm sure I have done this before but can't remember and
can't find any of my old files with an example.

Please help.

Jim