select data between workbooks?
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 |
select data between workbooks?
"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 |
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com