"Path\File Access" error in a Word macro

E

Ellen

We are having the following problems with some staff while others have no
problem at all.

Encountering "Path\File Access" error in a Word macro. The macro is failing
on the Kill statement for a document. The user appears to have sufficient
access as the document can be deleted manually through Windows Explorer. (I
also checked the users' access through security.) From what I can tell,
there is no difference between the drive mappings of the people having
problems and those who are not.

Here's an example of our code:

sOriginalFullName = ActiveDocument.FullName
(Example of sOriginalFullName value:
"O:\CISS\TEST\CHELSI\Generated\200593ED.doc")
Kill (sOriginalFullName)

Any information would be appreciated.
 
J

Jean-Guy Marcil

Ellen was telling us:
Ellen nous racontait que :
We are having the following problems with some staff while others
have no problem at all.

Encountering "Path\File Access" error in a Word macro. The macro is
failing on the Kill statement for a document. The user appears to
have sufficient access as the document can be deleted manually
through Windows Explorer. (I also checked the users' access through
security.) From what I can tell, there is no difference between the
drive mappings of the people having problems and those who are not.

Are all Word versions the same? How about Windows? Service packs?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
E

Ellen

All staff should be using Windows XP SP1 with Office XP SP3. I'll have them
verify the office version to make sure that they received the SMS package for
SP3.

If all are at Windows XP SP1 and Office XP SP3, any suggestions?
 
J

Jean-Guy Marcil

Ellen was telling us:
Ellen nous racontait que :
All staff should be using Windows XP SP1 with Office XP SP3. I'll
have them verify the office version to make sure that they received
the SMS package for SP3.

If all are at Windows XP SP1 and Office XP SP3, any suggestions?

Before killing the file, you have to close it.
Maybe that on some machines the processor is too slow and when you get to
the Kill instruction it has not released the hold on the file yet, so it
thinks it is still open?
Have you tried a Do Events before the Kill instruction?

Or, is there a difference with the way these machines are connected to the
network?

Do these machines always exhibit this behaviour, or only with certain files?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
E

Ellen

The person having this problem changed her macro and used the Do Events
before the Kill instruction. She hasn't had anyone come to her with this
problem since then.

Thank you for your help.

Ellen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top