Without seeing the code it's hard to say exactly what the problem might be.
Try putting a small delay before opening each file and see if that fixes it.

Tim.


"MarkS" wrote in message
...
No thats no right, The first one always loads fine and the next one has
the
problem

"MarkS" wrote:

Yes Its always the same ones but opening them and resaving them doesn't
help

"Tim Williams" wrote:

Do the files which give problems fail consistently ?

Tim


"MarkS" wrote in message
...
Hi Tim,
from a remote server, but some work fine and others don't

MarkS

"Tim Williams" wrote:

If it works fine when stepping through then most likely there is
some
delay
in creating or releasing the file you're trying to open.
Where does it come from ?

Tim

"MarkS" wrote in message
...
Hi,
In VBA I have this line
Workbooks.Open sAFMAPathName & sFileName

when in auto it gives a error message 'Unable to read file' when I
single
step (F8), it works fine.
This section of the code comes from another excel VBA code block
which
works
fine, if a bit slow.

Thanks