I have set paths to 3 specific files. I cannot figure how to loop through them
dim path1, path2, path3 as string
dim counter as integer
dim WB as workbook
path1 ="...\a.xls"
path2 ="...\b.xls"
path3 ="...\c.xls"
for counter = 1 to 3
set WB = workbooks.open("Path" & Counter)
counter = counter...