Sharing Files
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 |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com