copy external data

D

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
 
P

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
 
J

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
 
Top