Excel Get data from other workbook file (with some data handling)

Question

I'm trying to make an Excel-document ("target document") that automatically updates with information from another Excel-document ("source document"). New data will be added to the source document from time to time and when the target document is opened it must contain the new data added to the source. Every new row in the source must be copied to the target, and every row has an "order number" which makes it unique and identifiable.

I can't use links because later changes in the source document shouldn't cause changes the target document.

How do I do this?

Edit: I was planning on doing this in VBA.

Duplicate? http://stackoverflow.com/questions/17719498/excel-vba-compare-copy-worksheets-from-2-excel-files/17719799#17719799 — mike27015, Jul 19 '13 at 08:37

score 3 · Accepted Answer · answered Jul 19 '13 at 08:29

3

you can adapt and modify the code at http://usefulgyaan.wordpress.com/2013/04/26/export-data-one-excel-file-to-another-without-opening-them/ so that when the target workbook is opened, it updates data from the source workbook.

answered Jul 19 '13 at 08:29

Max Fraudy

56
3

score 1 · Answer 2 · edited May 23 '17 at 10:32

1

You might want to take a look at this post, which I answered reccently. It has the same principe that you are looking for. excel vba compare & copy worksheets from 2 excel files You didn't tell us if you plan to do it in VB.NET/C# or VBA. The solution given is in C#/VB.NET translated.

edited May 23 '17 at 10:32

Community

1
1

answered Jul 19 '13 at 08:39

mike27015

686
1
6
19

Excel Get data from other workbook file (with some data handling)

2 Answers2