10 ways to reference Excel workbooks and sheets using VBA Your ... active workbook, but the function is in a workbook named 0908002.xls. The Workbooks collection contains all the open Workbook ...