Hi all

Hopefully a nice and simple one.

I have the following which code which is on a number of machines on th
network. All this will do is allow the user to open a file that i
stored on the shared drive.

But only one person is able to access it at once. even if they say ye
to the read only message box, it causes the macro to fail.

Any ideas

Thanks

david

Sub Open_viewa()

Workbooks.OpenText FileName:="j:\Invoice Queries 2004 Master.xls"
Origin:=xlWindows

End Su

--
Message posted from http://www.ExcelForum.com