is it possible to make it so that range("D3")(from
workbook1)=range("D4").value(from workbook2) without opening workbook
2?

i will be working on workbook 1 and on the click of a command button
will want some range from workbook2 but will not want this workbook
open, it has been possible to open this workbook selcet range("D4")
copy activate workbook 1 select range("D4") and paste but this is
inefficient as there are 150 cells that need to be transferred

if there is a more efficient code please help


--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576
View this thread: http://www.excelforum.com/showthread...hreadid=388169

"short_n_curly"
wrote in message
news:short_n_curly.1sdyf7_1121724377.099@excelforu m-nospam.com...
:
: is it possible to make it so that range("D3")(from
: workbook1)=range("D4").value(from workbook2) without opening workbook
: 2?
:
: i will be working on workbook 1 and on the click of a command button
: will want some range from workbook2 but will not want this workbook
: open, it has been possible to open this workbook selcet range("D4")
: copy activate workbook 1 select range("D4") and paste but this is
: inefficient as there are 150 cells that need to be transferred
:
: if there is a more efficient code please help

see if this may help
http://www.erlandsendata.no/english/...dacimportwbado
Paul D