Excel macro check for open Word document

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....
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top