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
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