| 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) from
Workbooks("A").Worksheets("A").Range("A") into Workbooks("B").Worksheets("B").Range("B") without opening Workbook A. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Values From A Non-Open Workbook?
='C:\Directory\[excelfile.xls]Sheet1'!A1
This formula will get the data for you (you will have to change the directory and file name of course). This formula only retrieves data not formulas HTH Regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Values From A Non-Open Workbook?
Thanks for your response. You mean enter
='C:\Directory\[excelfile.xls]Sheet1'!A1 as a cell formula? I am sorry but I think I was unclear about my problem. I am looking for a way to copy a range from an un-opened Workbook A into an opened workbook B using VBA. Can this be done? Thanks again for your consideration. "Crowbar via OfficeKB.com" wrote: ='C:\Directory\[excelfile.xls]Sheet1'!A1 This formula will get the data for you (you will have to change the directory and file name of course). This formula only retrieves data not formulas HTH Regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheet from one open workbook to another... | Excel Worksheet Functions | |||
| Macro to close workbook and re-open new copy | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
