Within powerpoint I have written a quiz for which I have a few lines of
vba code to write the results of the quiz to an excel file. As pupils
complete this, they each end up writing to the excel file, and I
therefore get an automatic analysis of which questions they found
difficult. The problem I have is that if two pupils finish at more or
less the same time, they can't both write to the excel file
simultaneously. Obviously one will start doing so, and the vba code for
the person who is second then ought to wait for the excel file to close
so it can then write to it. What I have found happening is a copy of the
excel results file gets opened up, which confuses the kids and me.
So what I need is a few lines of code in vba that if user B finds file X
is open by user A, it waits until the file is closed by user A and then
available to write to.

Can anyone help me with this??
Bernie Dawson

*** Sent via Developersdex http://www.developersdex.com ***