Greetings,

I'm a little out of practice with my VB, and haven't done (m)any excel
macros, but I have been put to a task:

I have a column of filenames in a spreadsheet. ex:
joe123.mp3
musicface.mp3
triscuit77.mp3

These files are in a directory below the location of the spreadsheet
which will always be: /_Archive/

I want to have the spreadsheet automatically check the column of
filenames for existence in the /_Archive/ directory. If the file does
not exist, or does not match the capitalization, change the filename's
color in the spreadsheet to red.


The purpose of this is to remove the human eyeballing part of the
process in which we often are missing files that we need.


--
PROTMAN
------------------------------------------------------------------------
PROTMAN's Profile: http://www.excelforum.com/member.php...o&userid=30430
View this thread: http://www.excelforum.com/showthread...hreadid=500951