I am opening a document in Word from Access using the "Shell" Method. Before anyone suggests that I just use GetObject() instead, in this case, that won't work as my Document has a Form Button on it and for some reason GetObject() causes a Missing Object Error if you have a Form Button on your document (yeah, weird I know).
Anyway, Shell seems to get around this.
Ok, I am using the vbHide Constant with Shell because I don't want the Document to Maximize while my code is running some processes on it. However, even though I have specified "vbHide" the Document is still popping up on my screen.
Anyone know what I am doing wrong?
Here is the code:
Shell "winword C:\ExecutiveDecision\" & vDocType & "\Templates\" & vDocType & vDocTypeSub & ".doc", vbHide