Excel does nt have change control.

Hwever by using an xla with a workbook_save event you acn record details on the workbook however in order to check diifs between files a copy is required. (Incase of overwrites.)

I dont want to have to save a file twice.
Even though it works its clunkly; I want it to be smooth.

This works on all files and if the file is large (which it most probably is), its going to take twice as long. (= end users not happy.)

I have looked into filecopy - but this requires a file to be closed. Have tried using the deactivate event but no joy.

Dont really want to go down the route of copy command line arg.
Any ideas anyone?