How to Check the Value of a Specific Cell in Every File in Directory

Hi,

There are approximately 120,000 files in the directory, and only about 8,000 are excel files
is there a way to list the value of cell 'AA63' (Specifically Sheets("FORM").Range("AA63")) from every workbook in the directory?

If the process involves opening each one, we can't afford that time, so if it can't be done, we can use an estimate.

Thanks,
-Drew

I think it can be done - what kind of files are they? csv/xls/xlsx/xlsm/xlb ?

But even opening each one via vba should only take a couple of minutes.

They're .xlsb
Thanks!