![]() |
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 |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com