Hi
I can no longer open Word from Excel. I have been using a macro for some time with no issues but all of a sudden the procedure generates a runtime error/server execution failed (80080005) on the following line Set wrd = New word.Application
The Microsoft Word Object Library is selected under References. I have tried the code with and without Word open, I have have also tried late binding but the problem persists. Oddly, I can open Excel from Word. The code I am using to open Word from Excel is
Sub openWord()
Dim wrd As word.Application
Set wrd = New word.Application
wrd.Documents.Add
wrd.Visible = True
End Sub
Any ideas would be really appreciated.
Thanks
Caroline
I can no longer open Word from Excel. I have been using a macro for some time with no issues but all of a sudden the procedure generates a runtime error/server execution failed (80080005) on the following line Set wrd = New word.Application
The Microsoft Word Object Library is selected under References. I have tried the code with and without Word open, I have have also tried late binding but the problem persists. Oddly, I can open Excel from Word. The code I am using to open Word from Excel is
VBA Code:
Dim wrd As word.Application
Set wrd = New word.Application
wrd.Documents.Add
wrd.Visible = True
End Sub
VBA Code:
Any ideas would be really appreciated.
Thanks
Caroline