Just a quick one.

Is it possible to pass variables across dirrerant workbooks.

Eg. Take a variable from a file production macro on ExcelBook1.xls
and pass it trough a formatting macro on ExcelBook2.xls

??