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.

This is very easy.
Check out dsofile - look for it at www.pmvs.org/access or on msdn
complete with examples.

HS

"Mobin M" <(E-Mail Removed)> wrote in message
news:193f301c38723$cf5dc520$(E-Mail Removed)...
> 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.