Linking folder information with Excel 2007
Hello. I am working on an Excel 2007 workbook for the company I am working
for. Everything is set up great and works just the same. Here's my problem.
I have a link (hyperlink) on my worksheets to open a specific folder on the
server to view the files inside of that folder. What I'm wanting to do is
have excel monitor that folder and create a worksheet with information on
what's happened to those specific files. If the file has been deleted, when;
if the file was moved, where; and who might have done this (computer name,
location). I'm not even sure if this is even in the means of Excel or it's
capabilities. All help is appreciated and open to any other suggestions to
going about this.
Thank you.
|