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

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

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

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

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

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