I can't quite figure this out.
I want to run a macro the will:
-display an open dialog box for xlsm files only
-test if a value is TRUE in cell A1 of the chosen file without actually opening the file.
Can this be done? Can I retrieve numerical values without opening as well?