Mismatch error ?!

[eddg2011]

I have code that copies all the files from different workbooks that start with a certain file name. The code below works great if ProjID is a String, however it falls apart when I make ProjID into a variant.

Any help plz?

Please Login or Register  to view this content.

It stops here:

Please Login or Register  to view this content.

[AB33]

I think it is good practice to force your code to declare all variables by using "Option Explicit"

Please Login or Register  to view this content.

Despite not declaring ProjID as object, you are treating like one. You can not compare and use like with object, it has to be a value, so you need to loop through range in the ProjID

Please Login or Register  to view this content.

[eddg2011]

I put this code together for one file name. Now I want it to run for a list on Column A; which is why I'm converting to a range now.
How could I loop the loop?

[AB33]

Please Login or Register  to view this content.

[eddg2011]

You Sir,

ARE A GOD. THANK YOU! I've been beating myself up all weekend over this.