Trying to activate an open Workbook with a variable

You could use a variable to reference the workbook when it's opened.

Set wbOpen = Workbooks.Open( fileName:=fNameAndPath)

You can now use the variable wbOpen whenever you want to refer to the workbook the user selected.