Error Method Range of Object - Global Failed

Hi

I have created a directory to refer to various files and initialised variables accordingly. I recently added 2 more files to the directory but when I run the macro it gives me an error when it reaches the "Jo File". Not sure why the code is not able to assign the variable JoFile to Price Desk Quotesheet Jo.xlsx

I am only getting this error for the files recently added - Jo and TAW - hope someone can explain where I've gone wrong....

File attached with screen shots of code and directory

Thanks!

Hi

Im not sure I understand what you mean....sorry I am quite new to vba programming....

The project involves combining data from the files listed in the directory - For eg. Price Desk Quotesheet Jo, Price Desk Quotesheet Mia etc. into a master file. I earlier did the project with the files Mia,Bill,Jonas, Lars and Mario and it initialized the variables fine. But then I added in two more files - Jo and TAW and for some reason, the code is giving me an error when assigning Price Desk Quotesheet Jo to JoFile.

Any ideas why?