| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy linked cells content to an other workbook
Hi!
I would like to update the informations from workbook A to workbookB. These workbooks are similar but not necessary identical. So, I would like to preserve the formatting of workbookB. I use: Range(wsData.Cells(iRowTarget, iColTarget), wsData.Cells(iRowTarget, iColTarget)).Value = Range(wsDataOld.Cells(iRow, iCol), wsDataOld.Cells(iRow, iCol)).Value Is there a way to copy the linked cells content of the wb A (ex: =Path[.xls]B12) and keep the value shown in the workbookA (not updating the link)? Thank you! Alex -- Alex St-Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Content linked to other cells formula Content | Excel Discussion (Misc queries) | |||
| HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS | Excel Discussion (Misc queries) | |||
| Copy sheets with content into same workbook | Excel Programming | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| How do I find cells with linked content | Excel Discussion (Misc queries) | |||
Linear Mode
