Mackeral
Board Regular
- Joined
- Mar 7, 2015
- Messages
- 232
- Office Version
- 365
- Platform
- Windows
Code:
"Full_Path_Name" is correct. I have very carefully checked that out.
Word_App = CreateObject("Word.Appliction") works.
When
"Word_App.Documents.Open Full_Path_Name"
executes, VBA starts "Running", and nothing I can do in Excel does anything to stop it.
I will get an message about Excel waiting for another process to complete (opening the file I guess).
When I look at Task Manager, I see that Word is running 2 processes.
If I "End" the Word process in Task Master, then Excel breaks with a debugging error.
Any idea what's going on or even better how to make it work.
VBA Code:
On Error GoTo Doc_Open_Err
Set Word_App = CreateObject("Word.Application")
If Word_App Is Nothing Then
MsgBox "Can't start Word.", vbExclamation
Else
Word_App.Documents.Open Full_Path_Name
Word_App.Visible = True
End If
"Full_Path_Name" is correct. I have very carefully checked that out.
Word_App = CreateObject("Word.Appliction") works.
When
"Word_App.Documents.Open Full_Path_Name"
executes, VBA starts "Running", and nothing I can do in Excel does anything to stop it.
I will get an message about Excel waiting for another process to complete (opening the file I guess).
When I look at Task Manager, I see that Word is running 2 processes.
If I "End" the Word process in Task Master, then Excel breaks with a debugging error.
Any idea what's going on or even better how to make it work.