Hi everyone!
Dunno if this is a quick question or not!
In excel, i would like to have a cell look up to see if a file exists
on a harddrive.
For instance.
the cell will either say OK or not done.
OK would be if it can find the file on the harddrive i.e an excel file
containing serial numbers of a particular computer brand. So the
different cell headings above would be IBM, ACER, etc. the cell below
these would then search for a file containing acer or ibm and if it
finds it it will then put either OK or Not Done if not found.
I would want it to search for the name of the file that is in another
cell or has part of the filename with in it.
Any advise would be greatly appreciated.
Cheers
Joel
--
dj_siek
------------------------------------------------------------------------
dj_siek's Profile:
http://www.excelforum.com/member.php...o&userid=31247
View this thread:
http://www.excelforum.com/showthread...hreadid=509219