I am attempting to open about 650 excel files in a folder and I want to use a for loop to do it. I have tried just throwing a for loop at the begging of my code that increments to 650 and the rest of my workbook manipulation after that. However whenever I go to open a workbook with the variable I am incrementing my for loop with in the name as opposed to 1, 2, 3, ...650 it says that I it can't find file y. I know that I can open everyfile in a folder and do the same manipulation to each workbook but the problem is that evey sheet in each workbook is also incremented by 1. If I could find a way of incrementing this text variable by one when it is in the "" ( for y = 1 to 650 Sheets("sheety") instead of having to call each sheet individually each time like workbook.("workbook1").Sheets("sheet1") workbook.("workbook1").Sheets("sheet2")...) I could use it for both applications and be done. Thanks.