copy external data

[Dan]

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

 

[PaulD]

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

: 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

 

[john]

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