sal21
12-23-2004, 03:28 AM
Have you an idea?
consider:
I distribute a wbooks to many user.
I dont know ahow amny user have opended the related wbok.
The wbook is the same for all.
I would want to insert a string value "OPEN" (Or the username of users) in the table CONTROLLO in autoopen of thiswbook and clear in autoclose thiswbook the realted record from each wbook....
Example:
The user01 open you wbook the field WBOOK1 is free insert in the table CONTROLLO field WBOOK1 the value "OPEN"
The user02 open you wbook the field WBOOK2 or the next is free insert in the table CONTROLLO field WBOOK2 or the first free the value "OPEN"
ecc...
in autoclosed of wbooks
The user01 close you wbook insert in the table CONTROLLO field WBOOK1 the value null
The user02 close you wbook insert in the table CONTROLLO field WBOOK2 the value null
ecc...
in effect controll if the wbooks is opened and closed...
In this acse if all wbook are closed start my macro ()...
As usual Many tks.
consider:
I distribute a wbooks to many user.
I dont know ahow amny user have opended the related wbok.
The wbook is the same for all.
I would want to insert a string value "OPEN" (Or the username of users) in the table CONTROLLO in autoopen of thiswbook and clear in autoclose thiswbook the realted record from each wbook....
Example:
The user01 open you wbook the field WBOOK1 is free insert in the table CONTROLLO field WBOOK1 the value "OPEN"
The user02 open you wbook the field WBOOK2 or the next is free insert in the table CONTROLLO field WBOOK2 or the first free the value "OPEN"
ecc...
in autoclosed of wbooks
The user01 close you wbook insert in the table CONTROLLO field WBOOK1 the value null
The user02 close you wbook insert in the table CONTROLLO field WBOOK2 the value null
ecc...
in effect controll if the wbooks is opened and closed...
In this acse if all wbook are closed start my macro ()...
As usual Many tks.