open word using vba

Asked Jul 30 '21 at 00:13

Active Jul 30 '21 at 00:15

Viewed 21 times

I keep getting error runtime 424 when opening a word document from excel. I double-checked the file path as well. The file path seems correct.

Sub OpenDoc()
    Dim strFile As String

    strFile = "C:\Users\risha\Downloads\english_2850_paper.docx"    'change to path of your file
    If Dir(strFile) <> "" Then    'First we check if document exists at all at given location
        Documents.Open strFile
    End If
End Sub

edited Jul 30 '21 at 00:15

braX

11,506
5
20
33

asked Jul 30 '21 at 00:13

Shab Meh

Are you doing this inside of Word? Or in some other application (like Excel, looking at your tags)? 424 means it does not know what `Documents` is. – braX Jul 30 '21 at 00:16
I am using VBA code in excel to open a word document. – Shab Meh Jul 30 '21 at 00:26
Then take a look at my 2nd comment. – braX Jul 30 '21 at 00:31

open word using vba

0 Answers0