Help with VBA code that stopped working

[Kmac224]

Hello,

I have the following code that was working to open a file from a certain directory and it stopped working. Does anyone see anything wrong with the code? Thanks in advance!

Sub CIRS()
 
Dim DATstr As String
 
DATstr = Format((IIf(Weekday(Date) = 2, Date - 3, Date - 1)), "yyyymmdd")
 
Workbooks.Open "[URL="file://\\imports\preproc\archive\ABC\XYZ\Pricing_DEF_GHIJ\outbound\"]\\imports\preproc\archive\ABC\XYZ\Pricing_DEF_GHIJ\outbound\[/URL]" & DATstr & "\*ABC_DEF.csv"
 
    
End Sub

 

[Ruddles]

The file that you're trying to .Open - does it definitely exist?

If you do a Dir(filename) before you try to open it, what does that return?