Try something like this

first row is 1
last_ row=range("A65536").end(xlup).row
for i=1 to last_ row
workbook.open range("A" & i)
do something
workbook.close
next i

"Barb Reinhardt" wrote in message
...
I have a list of file names (with directory path included) in Column A of
a
worksheet. I'd like to generate a loop in VBA to access each of those
files and perform a sequence of activities on the list of documents. How
would I do that? The start and end row may vary.

Is there a resource that I could view that would help me with this?

Thanks,
Barb Reinhardt