I am trying to write a macro that opens several workbooks. The macro needs to open a workbook, print one sheet from that workbook close workbook and so on and so on. I have written macros in workbooks before only using information in that workbook. I can not figure out how to use the macro across workbooks. Please HELP!