Have you tried recording a macro while doing those steps?
Paul D

"Dan" wrote in message
...
: 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