S
Sandy
Guys,
I have a major problem with an Excel workbook that i created and have
been try to resolve this issue for a couple of weeks and my Bosses are
breathing down my neck.
Here is how it works:
I have multiple users using the excel workbook at the same time (they
will open as read only). Once they are done with the data entry they
run a macro. Which will copy data from this excel workbook opens
another file, which is saved in the Shared Drive (Network Drive) and
pastes it as the last entry made in that workbook. If another user is
using this file then it throws an error boxing saying that, "The file
is locked by another user for editing and try after 10 seconds". Then
saves the workbook that it opened from the shared drive and closes it.
The problem is that the macro is running ok till the point of opening
the file making the entry but then when it tried to save the file it
creates a temp file in the same location instead and deletes the
original file. So when other users run the macro again the file does
not get located and they get Run Time error 1004.
This problem is only happening 5 to 10% of the times and usually occurs
when multiple users are trying to save the file at the same time.
I did read the previous threads, the suggestions i got from there were:
It could be an Anti Virus issue. Norton is not scanning this folder.
The users have Read, Write as well as Delete access to this particular
folder.
All help will be greatly appreciated.
Thanks and Regards,
Sandy
I have a major problem with an Excel workbook that i created and have
been try to resolve this issue for a couple of weeks and my Bosses are
breathing down my neck.
Here is how it works:
I have multiple users using the excel workbook at the same time (they
will open as read only). Once they are done with the data entry they
run a macro. Which will copy data from this excel workbook opens
another file, which is saved in the Shared Drive (Network Drive) and
pastes it as the last entry made in that workbook. If another user is
using this file then it throws an error boxing saying that, "The file
is locked by another user for editing and try after 10 seconds". Then
saves the workbook that it opened from the shared drive and closes it.
The problem is that the macro is running ok till the point of opening
the file making the entry but then when it tried to save the file it
creates a temp file in the same location instead and deletes the
original file. So when other users run the macro again the file does
not get located and they get Run Time error 1004.
This problem is only happening 5 to 10% of the times and usually occurs
when multiple users are trying to save the file at the same time.
I did read the previous threads, the suggestions i got from there were:
It could be an Anti Virus issue. Norton is not scanning this folder.
The users have Read, Write as well as Delete access to this particular
folder.
All help will be greatly appreciated.
Thanks and Regards,
Sandy