VBA Runtime Error cant locate file location

[Snowlock64]

Whenever I record a macro the vba always adds an additional section on where to locate the file. As you can see below actual location for the file is located on the H: Drive but it adds an openfilename= in C Drive. A colleague on the same network as me created an identical macro which works fine.
I always get a runtime error message. I can delete the fewadditional lines but it’s a pain having to do that each time I create a macro.I am assuming its something to do with the personal xlsb but I am not sure. Anyhelp would be appreciated.

Workbooks.Open Filename:= _
        "C:\Users\Username\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\Copy of completed matters by case manager.xls"
    ActiveWindow.Visible = False
    Workbooks.Open Filename:= _
        "H:\PO KE\Reports For Rolling PIH\completed matters by case manager.xls"
    Range("A5:C18").Select

 

[DanteAmor]

I have the following doubts:
- What is your colleague's code?
- Why do you have to hide the window?
- What does the error say?
- On which line does the macro stop?
- What are the additional lines that you have to delete?