Help with incrementing a filename/text by 1

[marcusj07]

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.

 

[mvptomlinson]

In your loop, could you use:

Workbooks("workbook"&y).Sheets("Sheet"&y)....?

Tough to understand your paragraph of text, but it sounds like you have Workbook1 and Sheet1, Workbook2 and Sheet2, etc.? If that's not the case, try to explain more concisely, e.g.

"I want to loop through 650 sheets, named Workbook1 through Workbook650. In each workbook is one sheet, and its name corresponds to the Workbook name. For example, Workbook1 has Sheet1 and Workbook2 has Sheet2."

 

[marcusj07]

Sorry for the confusion on the post. That worked though thanks for your help