Trying to activate an open Workbook with a variable

Hi all,
I have a script which opens a user-defined workbook, and later on I need to be able to activate that workbook. I have the filepath for the workbook defined, and I've been able to pull the filename from the path and store it as a variable. However, I get a Runtime Error '9': Subscript out of range notification whenever I try to activate the workbook using the variable I have set. Yet, when I copy and paste the variable contents into my Activate command, the script works.

Please Login or Register  to view this content.

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3

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

Please Login or Register  to view this content.

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