Changing file attributes

  • Thread starter Thread starter Mobin M
  • Start date Start date
M

Mobin M

I am working on automating a survey conducted for my team.
To ensure anonymity of the workbooks submitted with data,
I need to write VBA code that would parse though the 'XLS'
workbooks present in a particular directory and then reset
the values of 'Last Saved By' in the Properties->Summary
window of the file. This is to be done on a win2K
environment with NTFS file system. The main purpose is to
ensure that feedback with data provided should be not
traceable to the login name though the properties window.

Thanks in advance for any suggestions.
 
Back
Top