VBA to Open Workbook not working

[chehsim]

Hi,

This macro was working previously. It has suddenly stopped working with
"Run-time error '1004':
Sorry, we couldn't find D:\Users\D801878\Int'l\Billing\2017_03\Billing Template_International_2017_03_SG.xlsx. Is it possible it was moved, renamed or deleted?"

My code is something like

Windows("_Macro_Duplicate Billing Templates.xltm").Activate
Src2 = Sheets("Parameters").Range("C12").Value
Workbooks.Open Filename:=Src2


where C12 is D:\Users\D801878\Int'l\Billing\2017_03\Billing Template_International_2017_03_SG.xlsx

The file is definitely in the said path and saved as the said filename! Please help!!!

Thanks!

 

[yky]

Between these two lines, add:

[COLOR=#333333]Src2 = Sheets("Parameters").Range("C12").Value

If Len(Dir(Src2)) <> 0 Then
Msgbox("File " & Src2 & " found.")
Else
Msgbox("File " & Src2 & " not found.")
End If

[/COLOR]
[COLOR=#333333]Workbooks.Open Filename:=Src2[/COLOR]

Can Excel find the file?

 

[chehsim]

Hi @yky,

Thanks for your help! I have found the error - that left me happy and feeling silly at the same time. It's a sneaky space that i missed.

But appreciate your time and help nonetheless!

Cheers!