aj311rules
New Member
- Joined
- Oct 11, 2006
- Messages
- 4
I have an excel macro that opens a specific Word document, makes changes to the document, saves the document, and then closes Word. The issue is that if Microsoft Word is already open when I run the macro, when it closes the Word document I opened, I receive the error:
"Word cannot save this file because it is already open elsewhere.
(C:\Documents and Settings\...\Normal.dot)"
Is there a way to check for open Word documents at the beginning of the macro and END if there is an open word document.....or a way to suppress this error?
Thanks....
"Word cannot save this file because it is already open elsewhere.
(C:\Documents and Settings\...\Normal.dot)"
Is there a way to check for open Word documents at the beginning of the macro and END if there is an open word document.....or a way to suppress this error?
Thanks....