Reference without writting to hdd

Originally Posted by DorianGrim

But this code must be placed in the Book1.

no-it will work in any workbook as long as the Book1 file is open in the same instance of Excel.