VBA Runtime Error 5147 - This File Could Not Be Found

[Alan_P]

Morning Guys,

My attempts at googling this error have been fruitless so any help would be much appreciated!

I have an excel sheet that creates word documents and is used by around 5-6 people, but for some reason for only 1 person they get a runtime error 5147 on the line in red below. He has access to the file that's linked in the cell (he can open it manually).

If Err.Number <> 0 Then
    Set wdApp = CreateObject("Word.Application")
End If
    
On Error GoTo 0

[COLOR=#ff0000]Set TempDoc = wdApp.Documents.Open(Sheets("Templates").Range("C21").Value)[/COLOR]
wdApp.Visible = True

Many Thanks,
Alan.

 

[Jerry Sullivan]

Hi Alan,

That one user might not have the same drive mappings as the other users. You could use a Universal Naming Convention (UNC)file path in that cell if it isn't already in that format.

You could also try having that user record a macro while they open the file manually from within MS Word. The path that is recorded might shed some light on why the macro from Excel isn't working.

 

[Alan_P]

Hi Jerry,

Using the UNC path worked a treat! Thank you very much!!

Cheers,
Alan.