MasterFile cannot be opened or accessed by several users on the same time

[Kimston]

MasterFile cannot be opened/accessed by several users on the same time. I have a Master Workbook which users from different workstations store data via the use of a VBA macro. In each workstation, users use a workbook called “TimeandAttendance” to track hours worked and attendance. At the end of the shift, each user must click on the button “send it” to send and store collected data. The problem arises when several users are accessing the Master Workbook at the same time. Does anyone know if there is a better way or method of accomplishing this task? These two files are in Excel, but I am thinking if I should use Microsoft Access? The error that we receive when the Master Workbook is opened reads like this: MasterFile.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen MasterFile.xls? Your help is greatly appreciate.

[xladept]

Hi Kimston,

Where is the "send it" button?

[Kimston]

Xladept,
Take a look at the new TimeandAttendance file. I have included the control buttom.

[xladept]

Hi Kimston,

Try this:

Please Login or Register  to view this content.

[Kimston]

Mr. XLAdept, I used to your code in the TimeandAttendance file and it worked perfectly. I ran this file several time to create enough data in the Master worksheet. Once I had enough data, I went and created a table, so it can automatically refresh the data in the Pivot Table that I also created. However, If I run and click on the TimeandAttendance control bottom, I get incomplete information such as ProductionDate, Supervisors, Department and shift. I believe that once I created the table, this codes stop working. Please take a look at the updated files that I uploaded again. Thank you very much for your time.

[Kimston]

Does anyone knows how I can accomplish this task?