TryMyVariable = Workbook("TestBook1.xls").sheets("Sheet1").cells(1,2)orMyVariable = Workbook("TestBook1.xls").sheets("Sheet1").Range("b1")