Concurrent Saving

[MattShoreson]

Does anyone know if this is possible?

Saving a file to multiple (2) locations at the same time?
ta,
Matt.

[sihvonma]

Hi,

That is not possible. I mean if you mean really at the same precise time.

This is due to the fact that a processor can truly work with only one assignment at a time (1 save)...Multi-prosessing is only "virtual".

Consecutive saving is of course possible. For an example in a loop so for the end user it looks like he would be saving at the same time for two locations.

Interested: Why would you want to save into two locations at the same time?

BR,

M

[MattShoreson]

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?