I want to do a code in Excel because I’m new to VB. I am trying to have the code search for a value in a (unopened) file but the file name I want to have it search is in a cell…

Example:
A B
1 CODE TOTAL
2 1234 (Need Output/Code here for file name that is in A2)
3 5678
4 9012


I want the code to search in a folder (say C:\Projects\Quantities) and look at any .xlsx file that has that name shown in the corresponding column A cell (Example: 1234.xlsx). I want it then to output the cell that’s in $F$26 (value would be from 0 to 100,000) in 1234.xlsx. I tried maybe putting ‘A2’ into the cell code but it’s just looking for the text rather the cell.

The thing is that Column A will change depending how many files are in said “C:\Projects\Quantities” folder. (Able to get that from Data==>Get Data. Currently trying to write my first Macro for that).

Any help or guidance about this issue would be helpful and most appreciative.