Run Time error 9 - Subscript out of range

Please see the attached Word file for more details including screen shots.

When I execute the statement...
Set vWB = Workbooks("C:\Users\Ritsick\Documents\Red_Compass\DRA\DRA Summary.xlsx")

I get the following error...
Run-time error '9':
Subscript out of range
Who is Participating?
GrahamSkanConnect With a Mentor RetiredCommented:
The Workbooks collection comprises all the workbooks that are already open in the application.

If you want to open one, use:

Set vWB = Workbooks.Open("C:\Users\Ritsick\Documents\Red_Compass\DRA\DRA Summary.xlsx")

Open in new window

To set the variable to an already open workbook, just use the name

Set vWB = Workbooks.("DRA Summary.xlsx")
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.