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

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

Dan,
if you read my earlier response to your 1st post I included a link to Ron
DeBruin site which explains how to do what you are asking.

"I would also suggest that you visit Ron's site for more informed guidance on
copying data between workbooks."
http://www.rondebruin.nl/tips.htm

--
jb


"Dan" wrote:

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