Opening Word documents when there is a problem

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
 
A

Alan

Let me rephrase this: In Word VBA, instead of using this:

Word.Documents.Open FileName:=aWordFileName, Visible:=True

to open a Word document, is there a way to .avoid being prompted when
the last time this document was opened, there was a problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top