Copy linked cells content to an other workbook

A

Alex St-Pierre

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 9 subscript out of range - assigning array to variable 0
trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this d 0
retrieve data from different workbook 1
Cell values to an array, then array transpose to another workbook 8
Copy Worksheet to specific row in another workbook 0
Referring to Cells 4
Insert Row based on count and copy range to inserted rows 2
Copy Multiple Areas from One Workbook to Another 4

Top