copy external data

  • Thread starter Thread starter Dan
  • Start date Start date
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
 
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
 
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
 
Back
Top