- No. It's never used by more than one user at a time
- Yes.

Thank you for your help. I had to re-write the whole thing bypassing the
issue. I made it work without copy/cut/paste.

Thanks you again

"sebastienm" wrote:

- Is the book in shared mode?
- do all computers are running same OS/Office version?

I searched this newsgroup for similar issues (looking for "network error"):
----------------------------------------------------------------------------------
- "This'll stump you! Problem with Copy Sheet between Excel"
This is speculation but you may be having problems because of the
AccessMode specification. It might be hard to debug remotely but does
the client have problems with the 2nd (or subsequent) attempt to create
the file? If so, it increases the likelihood of the AccessMode causing
the problem.
Can you ensure that the file is always under exclusive control before
you try and overwrite it? Or, as a test, can you create a new file
name each time? Does the problem still occur?
If the file is on a network drive there might be additional
security/sharing issues introduced into the analysis by the network
management software.
Finally, you may want to search support.microsoft.com for your error:
http://support.microsoft.com/search/...t.aspx?query=%
22file+access+error%22
--
Regards,
Tushar Mehta
-----------------------------------------------------------------------------

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"vat" wrote:

The macro is in a Module. I am sure, the problem is in some local settings,
since the program executes good in one PC and does not work on another.