Unable to open Word file from Excel
Here's my code:
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = False
Set WordDoc = WordApp.Documents.Open(myFile)
For some reason I keep getting a runtime error 5457,
which says something like "File is open or being used".
I know for a fact that the Word file is NOT open and nobody is
using yet. I've even tried different Word files, but still the
same result. Does anyone know what the problem might be?
Is it related to the file permissions?
|