VBA code to pull data between workbooks

[codesRus]

I was wondering if there is a vba code to pull data or to link from one workbook to another? I'm looking for when data is added to an entire workbook can it update another workbook that is currently not opened.

[Medpack]

Hi CodesRus,

You can definitely link data. Just set the property of the linked workbook to "True" as noted below. When the workbook containing the linked workbook is opened, it will pull-in the latest infromation from the linked workbook.

Please Login or Register  to view this content.

If you're looking to insert data directly into the workbook (as opposed to having an icon style linked workbook), then you would have to write some kind of code that pulls in updates each time the main workbook is opened - Which is possible, but time consuming processing wise.