How to activate Word document and execute word templete from Excel VBA
Is any body can help me?
That question have been answered here before, but something like this will do:
- dim obj1 as object
-
set obj1=createobject("word.application")
-
with obj1
-
.documents.open ("c:\myDoc.doc")
-
.visible=true
-
.[any word's command]
-
end with
Now, remember that if you have a word constant, it wont be recognized in your Excel VBA, so instead of writing the constant, write its numeric value.
HTH