Autofileter criteria from another workbook

[Muhamed Faizal]

Hi,

Sub test()
Rows("7:7").Select
Selection.AutoFilter
Range("A7").Select
ActiveSheet.Range("$A$7:$BU$10000").AutoFilter Field:=16, Criterial1:="Offshore In Progress"
Selection.AutoFilter Field:=8, Criteria1:="<=" & Workbooks("Faizal.xlsx").Sheets("Request Details Sheet").Range("J4")
End Sub

I want the criteria should be taken from another workbook. I tried to add workbook name but it doens't work.

What did I do wrong here?

Thanks in advance