use entered info to find and open file

Hey All,

i have looked all over and I cannot seem to find any info on this forum or even online.

I was wondering if it was possible to open file BrianJohnson.xlsx if cell A2 says Brian Johnson. Basically, I am looking to open a group of files, all in the same folder, but only the ones that have the name typed into column A.

I appreciate any feedback!

BrianJohnson.xlsMaster File AmeriCorps Code.xlsmWasWodge, how would i incorporate that into the code i already have? Sorry I am new to this and I want this to work and not take out pieces of the code that are already working for me.

Please Login or Register  to view this content.