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