Hello Everyone,

I have a spreadsheet that containts 2 columns-Part Number and Drawing
Location. The sheet looks something like this:

---A------------------------B-------------------------
Part#-----------Drawing Location
Part 1----------c:\drawings\part1.xls
Part 2----------c:\drawings\part2.xls
Part 3----------c:\drawings\part3.xls

Is there a way to make a macro that will look at the cell containing
the file path, open that Excel file, print the workbook, close the
file, move to the next cell down, open/print/close...etc until it
reaches a blank cell?

I'm very new to macros, so any help would be greatly appreciated.

Thank You,

-Chad