I have a problem that I believe is being caused by time delays on a network,
and I need to find a workaround.

My workbook has a macro which opens a further workbook, using this line of
code...

Workbooks.Open
Filename:="\\staff-filestore\shared\hu\hu-admin\admin06\DATA.XLS",
ReadOnly:=True

This works for some users and not for others.
All users are already logged in to the same corporate network, all using the
same OS and the same browser and the same version of MSOffice. However, some
computers are newer and faster than others, and some network sections are
limited to 10Mb whereas others are 100Mb.
It seems that a fast computer on a slow network tends to fail on this line
of code, with a "file not found" error. Interestingly, if you enter the
debugger and press f5 (to continue) then the macro runs just fine, which
seems to suggest that the time delay has given the network a chance to
respond.

Is my hypothesis plausible, and if so what can I do to workaround?

--
Adrian D.Bailey, Information and Systems Manager, Dept.Human Sciences
Loughborough University, Loughborough Leics, LE11 3TU, UK.
Tel: 01509 223007 Fax: 01509 223940

Community Warden, Storer and Burleigh Areas. Out-of-hours Tel: 01509 563263
--