Copy linked cells content to an other workbook

Alex St-Pierre

Guest

Posts: n/a

28th Mar 2008

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

« Strange find and replace query | file sharing »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linked Cells Staying With Cells Once Linked Workbook Update.	paul.morriss@wlucy.co.uk	Microsoft Excel Worksheet Functions	0	6th Jun 2006 09:32 AM
How do I find cells with linked content	=?Utf-8?B?Q293dG9vbg==?=	Microsoft Excel Misc	5	19th Jan 2006 12:38 PM
Copy a range of cells in an unopened workbook and paste it to the current workbook	topstar	Microsoft Excel Programming	3	24th Jun 2004 12:50 PM
Copy sheet from one workbook to a new workbook without having them linked	Gilbert Aponte	Microsoft Excel Misc	1	18th Jun 2004 09:46 PM
How to copy content of linked document?	Brett	Microsoft Word New Users	0	26th Oct 2003 04:46 PM