johnboy691 Posted July 1, 2008 Report Share Posted July 1, 2008 Hi Everyone: Has anyone had any experience with having a ASCII Delimited Text File on a share drive and multiple (dozens) of people accessing that file using a macro expres macro using the ME command to read the file? I would like to know if someones macro is reading the file and another persons macro needs to read the same file at the same time if there are any access or read problems for the second or third or .... persons getting access at the same time? Thanks for any comments anyone can give me! John Quote Link to comment Share on other sites More sharing options...
rberq Posted July 4, 2008 Report Share Posted July 4, 2008 I'm going to guess that it will work just fine. If you have two or three PCs to test with, try it by putting a big file on the server (big, so that reading it won't be practically instantaneous). The embed some delays in your macro if necessary, to slow it down a bit more, and start the macro on all the PCs at once. The only reason for the delays is so the macro won't finish on the first PC before you have a chance to start it on the others. Or to prolong the test without building in delays, you could have a repeat loop in the macro to process the file ten or a hundred or a thousand times, just to force more contention among the several PCs. Let us know how it comes out. Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted July 7, 2008 Author Report Share Posted July 7, 2008 Hi Everyone: Has anyone had any experience with having a ASCII Delimited Text File on a share drive and multiple (dozens) of people accessing that file using a macro expres macro using the ME command to read the file? I would like to know if someones macro is reading the file and another persons macro needs to read the same file at the same time if there are any access or read problems for the second or third or .... persons getting access at the same time? Thanks for any comments anyone can give me! John rberq Thanks for you comments. I took your advice and set up an excel file with 65,000+ lines and 28 columns full of data and saved as a csv file to a share drive. I made a macro that looped requesting a find of a random number every loop. I started that macro on 28 computers (at the same time) and haven't had an error out at all. If anything I may notice a slight delay other than running on just one...but only slight. Hopefully this information will help others. John Quote Link to comment Share on other sites More sharing options...
rberq Posted July 7, 2008 Report Share Posted July 7, 2008 Well, that WAS a thorough test! Thanks for the feedback. I'm sure this will be useful to others. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.