Pull Data With Criteria From Closed Workbook

[animas]

    Range("TableRange[#All]").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Range("Criteria"), CopyToRange:=Sheets(3).Range("A1"), Unique:=False

I could pull data from another worksheet of same workbook using above code.

I need to pull data with criteria(criteria will be on existing workbook) from a different closed workbook. How do I do that?

Thanks.

 

[GlennUK]

Have a look at pulling external data using MS Query ( instead of Advanced Filter ).