My understanding is that you have no control over the order in which the
dire command reads files off a disc. I guess that its something due to
the actual locations on the disc.

What you might try is to change your Dir call to a more specific one
with a loop

e.g.

Dir "C:\....\1*.xls the first time around and

Dir "C:\....\2*.xls the first time around etc.

This assumes that the file names are predictable.

Hope this helps.

Martin


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533117