Macro error

V

V-ger

A computer of a client of mine has me baffled. I created a simple file/open
macro to open a letterhead template as read-only and 9 times out of 10 she
gets an error message that requests a debug. The message says 'file not
found...', but the file is there, on the server, and occasionally the macro
works just fine. Her macro security is set to Medium, her "trust all" under
trusted sources (Word 2002) is checked, what else could possibly be
interfering - just sometimes - with this simple macro? Please help. Thank
you.
 
B

Beth Melton

It could be the workstation is AutoDisconnect. When the error occurs,
open "My Computer" and note the Network icon. It may display with an
"X". Typically if you select the network drive again then it
re-establishes the connection and many times this can go unnoticed.

Here's more information on AutoDisconnect:
http://support.microsoft.com/?kbid=297684

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top