Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Select same range from large number of workbooks | Excel Worksheet Functions | |||
Select other workbook to select data in a macro. | Excel Programming |