Any idea how I can fo the following:

1) open another sheet called "reference.xls" located on "C/Temp"
2) Copy the value of "sheet 1" from "reference.xls" to my original sheet
3) close "reference.xls"

Many thanks,
Dan