Creating an automatic log of filenames copied to flashdrive?

T

Trish Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving sheets as their own workbooks? 1
Collections - logging file details to a table 0
Automating a copy from Excel to Word 5
Including paragraph text into filename 3
Having filenames of attachments show up in the body of an email 1
Creating a Log 4
Date Copy and column adjust macro 0
Save Workbook As .xlsx to Remove Macros? 2

Top