Hi everyone,

As part of our data security I was wondering if it would be at all possible
to use VBA in an Excel workbook to simplify the process of logging filenames
copied to removable media such as a memory stick.

What I had in mind was a sheet with headings Date; Path/Filename; Date
removed from Stick.

If I could automate the first part i.e documenting date and filename then I
would have at least some hope of getting users to agree to logging copied
files.

Does anyone have any suggestions or maybe there are already solutions out
there that I am blissfully ignorant about?

Thank you
--
Trish

Not sure this is what you are looking for, but it won't hurt to look:

http://xlvba.3.forumer.com/index.php...showt opic=67

"Trish Smith" wrote:

Hi everyone,

As part of our data security I was wondering if it would be at all possible
to use VBA in an Excel workbook to simplify the process of logging filenames
copied to removable media such as a memory stick.

What I had in mind was a sheet with headings Date; Path/Filename; Date
removed from Stick.

If I could automate the first part i.e documenting date and filename then I
would have at least some hope of getting users to agree to logging copied
files.

Does anyone have any suggestions or maybe there are already solutions out
there that I am blissfully ignorant about?

Thank you
--
Trish