Opening a workbook already open by another user

Hi,

Firstly thanks for the help I've already had, just have another question if I can be so cheeky.

The macro below copies data from 10 cells on the open workbook, opens a master workbook called 'test', pastes it into the next free row, saves 'test' , closes it and then clears out the cells from the original workbook so it can be done again. Problem is that as up to 30 people could be using the same 'test' workbook and there is the chance that it could be open already, is there any code that can be added to the current macro that would look to see if the workbook was already open then wait a few moments and try again if it found it so.

Current macro:

Please Login or Register  to view this content.

Many thanks in advance

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here