Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Values From A Non-Open Workbook
I wish to copy data (values only) fro Workbooks("A").Worksheets("A").Range("A") int Workbooks("B").Worksheets("B").Range("B") without opening Workbook A. Is this possible? Thanks -- Jeffrey_Chcg Posted from - http://www.officehelp.i |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Values From A Non-Open Workbook
Not possible with copying, but you can link the cells of Range("B") with the
cells you want to pull data from, with formula. Any time you open Workbook B it will prompt you to update links. Gabor "Jeffrey_Chcgo" az alábbiakat írta a következő hírüzenetben: ... I wish to copy data (values only) from Workbooks("A").Worksheets("A").Range("A") into Workbooks("B").Worksheets("B").Range("B") without opening Workbook A. Is this possible? Thanks. -- Jeffrey_Chcgo Posted from - http://www.officehelp.in |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Values From A Non-Open Workbook
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet from one open workbook to another... | Excel Worksheet Functions | |||
Copy Values From A Non-Open Workbook? | Excel Programming | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
copy row to another open workbook | Excel Programming | |||
Does Workbook need to be open to copy to..from vba | Excel Programming |