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

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

Copy Values From A Non-Open Workbook
 

Thank you for your response

--
Jeffrey_Chcg
Posted from - http://www.officehelp.i