I am having trouble figuring out how to open folders based on a variable that I have already set.
The Variable is coming from a For Each Row in an excel document. For Example, the First Line in the Excel document is Doe, John and the second is Smith, Bob. I want to open a File called “Doe, John.pdf”, extract data, close the document, and then open up the file “Smith, Bob” and do the same tasks.
I have the variable working fine to give me the correct names, I just need help figuring out how to edit my “Open Application” activity to recognize the variable Names I am trying to use.