Thanks :) It's XL2010.

I seem to have got it working, touch wood, through a combination of:

1) Storing the list of filenames in an array, i.e. doing the DIR loop
first not during the main code.

2) Putting in application.waits of 1 second where files are being
opened, closed or saved, to give Excel and the network drive time to
sync

It seems to be working so far.

You can do all this using ADODB without having to open the files being
updated. Have a look here for how to...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion