Getting value in a file from a file whose name is in a cell

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.

Try to run this one

Please Login or Register  to view this content.

Thank you. I'm going to try to learn how to do VB (Visual Basic) so when I do, I will try to use this (I presume that this is VB). Would you have any idea how to convert this for a single cell code in Excel?

That was very helpful. I have to adjust the code a little bit but I will get it working. Thank you.