Opening a workbook based on a cell value
Not sure if this is possible but here goes:
I need to be able to look through a column of cells and
open each workbook whose name corresponds to the value in
each cell one at a time. Example:
Column H
931C
941
921B
900B
In this example it would look at column H, open 931C.xls,
do some "stuff" (including closing the workbook after it's
done),open 941.XLS, do its "stuff", open 921B.xls....
The "stuff" I can handle, just have no clue how to loop
through the column and open the files like I described.
Any help would be GREATLY appreciated.
|