Read text in excell cell, then find corresponding folder

Question

I want to read the text from excel and find the corresponding folder in windows. Let say, I have an excel file containing the list of the folder I want to open in file explorer.

and here is my folder.

So I want to read from excel file on cell A2, then after reading “dotnet”, I want to find in the screen, where is “dotnet” folder. I have tried using function “text exist”. However, it wasn't working. Can anybody tell me which function should I use to find the corresponding folder?

Answer 1

One way to go about this would wbe using read range activity and reading all the data from excel .Now that you have the directory, you can use 'for each' item in datatable and simply pass a hot key (win+r) to open run command then use type into to type your directory this should open the folder .