PDA

View Full Version : Autofilter based on cell from another workbook



crujazz
05-22-2013, 03:10 PM
Dear all,

I've two workbooks, contacten.xls and Projectlijst -STD-.xls

In the projectlist workbook i have at sheet TEST!A31 an ID. I want to use the cell content TEST!A31 as a criteria for autofilter (VBA) in contactlist.

In [contacten.xls]Blad3!A2 i've put as a test an ID. The VBA code in contacten.xls works aslong as i'm in contacten.xls

Basicly, i want to open my Projectlijst.xls and automaticly a VBA code checks if TEST!A31 has a value, if so use cell A31 as a criteria for the VBA-code in contacten.xls but contacten.xls is a closedfile.

I'm out of ideas so i've included the files, maybe someone can help me out with it.

Much appreciated