What does Word VBA error 5180 mean?

I have a macro that a remote offsite user is reporting an error 5180 when the Macro I've written ends. At the end the code attaches a template and then password protects the document. I can't replicate the error myself. Any ideas what it could be?
LVL 1
Sparky191Asked:
Who is Participating?
 
Joanne M. OrzechConnect With a Mentor Manager, Document Services CenterCommented:
I think the error message means that it can't access the document.  Does the remote user have the template on his/her PC or laptop?  Something in your macro isn't available to this remote user.

0
 
Joanne M. OrzechManager, Document Services CenterCommented:
Are you using an access database in your macro?  If so, see this:
http://support.microsoft.com/?kbid=815183

If not, tell me what version of Office you're running and perhaps you could send me the template.  I've seen this before (unfortunately due to my own novice VB skills:(  but can't quite recall right now what caused it.  Will investigate further for you.
0
 
Sparky191Author Commented:
Sorry its Word XP and no I'm not using anything else like Excel. I don't understand that link you posted. What does it mean? How can I email you? whats your address?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Joanne M. OrzechManager, Document Services CenterCommented:
Ok Sparky - sorry -  people often don't mention what version of Office they're running.  I don't have XP but the same type of problems seem to creep up in all versions in different ways.  
0
 
SteinerCommented:
Maybe you should post the code here and try to isolate where the error occurs (at then end of the macro does not necessarily mean the macro is ended correctly, usually it's just aborted. So try to find out what things the macro has not done yet to isolate the point where the error might occur.
0
 
Sparky191Author Commented:
Sorry I mean I'm not using Access.

Its a remote user I can't replicate the error so I don't know where its happening, the user reports its at the end. That could mean anything however. I was hoping that someone might know what the error means which would point me in the right direction in the code.
0
 
GrahamSkanRetiredCommented:
What is the error message? If the code isn't locked, you should get the user to report the VBA line that it fails on.
0
 
Sparky191Author Commented:
I have an autoupdate routine where the template automatically loads the latests version template. The user had renamed the local template for some reason and it couldn't find itself literally.
0
 
Joanne M. OrzechManager, Document Services CenterCommented:
Thanks for the points and grade Sparky!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.