I know this isn't an excel answer, if you are comparing file structures
of a hard drive versus your server, you should look into some FTP
programs and server back up programs. They would do a much better job
of keeping track of files, syncronizing and alerting you to missing
files. I can't recommend one off the top of my head, but i know our
Server Admin has some nifty tools that run one or twice a day
syncronizing and backing up different drives. do some google
searching, or talk to some server guys. But I think it might be more
helpful.

also, if you are looking to compare data and run reports, you might
want to consider building a small access database and then you could
run queries that compare only parts of the file name, and you could
also set it up to just run a report and spit out the files you need to
look at. I would be fairly easy to set up a data base like that. I am
not as familiar with access and VB as i am with mysql and php, but i
know that it is possible in php and mysql to create a cron job that
runs through a site and stores the path and file name as a string in
the data base. I am sure you could do this with vb and access.

trav


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=515249