Hello everyone,

All of my workbooks in a directory have the same format. As it stands
now, I open each one manually, and have my code extract the data from a
sheet and aggregate it on the appropriate sheet of my report file.

All I am looking to do is open each workbook, perform my macro, close
the work book and open the next. I figure to do this correctly, the
macro would have to count the workbooks in the directory (there are
51), and from 1-n, open work book, call my macro, close workbook, next
n.