Error when opening workbook with variable name in VBA: Subscript Out of Range 9

[kelseygueldalewis]

I have a folder with 2 workbooks. One with macros named VBAHelp_11111.xlsm and one without macros named 11111.xls. The code of the macro enabled workbook *should* 1. ask the user for a run number 2. Use that run number to open the excel file with that run number as a name

Ex. run = 11111
Program should open 11111.xls

Since they are in the same folder, I use a variable path to assign the location. However, when I try to open the folder using

Please Login or Register  to view this content.

I get the subscript out of range error. I have even added a sub function that checks to make sure all of the workbook names match but still no luck. Please help!

Here is the full code, and I have attached the files that in my desktop, are the only 2 files in a folder titled TPR_Help.

Please Login or Register  to view this content.

[shg]

Wrong syntax.

Please Login or Register  to view this content.

[kelseygueldalewis]

@shg Thank you for the quick reply! That solved it perfectly!