A
Alan
In some VBA call, I have the following statement in Excel to open a
Word document:
Word.Documents.Open FileName:=aWordFileName, Visible:=True
However, in one case it just hung there. Periodically, Excel would
say that it was waiting on another application to do something with an
OLE object.
When I opened the file myself in Word, it prompted me, because
there was a problem opening it the last time. Once I OKed this, the
code above worked fine.
My question: Is there a way to avoid this prompting business in
this case? Also, is there a way to determine a status of opening a
Word document?
Thanks, Alan
Word document:
Word.Documents.Open FileName:=aWordFileName, Visible:=True
However, in one case it just hung there. Periodically, Excel would
say that it was waiting on another application to do something with an
OLE object.
When I opened the file myself in Word, it prompted me, because
there was a problem opening it the last time. Once I OKed this, the
code above worked fine.
My question: Is there a way to avoid this prompting business in
this case? Also, is there a way to determine a status of opening a
Word document?
Thanks, Alan