Hi All,
I am at novice level.
I have been reading other "not dis-similiar" threads, but have failed to grasp what bits of code I need/dont need.
So I'll ask the question.
Background.
I have a macro, that resides in an excel file.
The macro does this.......
copy multiple variables from excel sheet1
open specific word document_1
paste those variables in the correct place
delete specific paragraphs (based on excel variables)
save file as document_2
The macro works very well indeed.
Question
There may be a problem occuring if either document_1 or document_2 is open.
I thought the way to go would be this...
Test if Word App is open
If Yes, then stop excel macro (with excel msgbox message)
If No, then continue.
So, how do I test if Word App is open, please.
My relevant code that may be of use.....
ThanksSet objWord = CreateObject("Word.Application") objWord.Visible = True Set objDoc = objWord.Documents.Open("I:\HOFolders\Raymond\Word Development\Ex 08 - semi final\HR Doc B - Template.doc")