I do a similar thing on some workbooks. I "archive" them at various times by
directing the file to be saved in a special ArchiveDirectory, and append a
DateTimeCode to the filename......that way I know by looking which file it
is, and WHEN the archive was saved. I then go ahead and re-save the same
file back to it's original filename/directory, all in the same macro.

hth
Vaya con Dios,
Chuck, CABGx3



"Allen" wrote:

Mutliple users access a common workbook to make entries. When saving, I want
the workbook saved under the common name, but also saved as a separate file
that will provide an audit trail and backup if the original is damaged. I
have seen this done with a hex filename created, but I have no clue as how to
do it.
--
Allen