Hey guys,

So I am wondering, is it possible to copy data from one Excel file (either Excel version 2003 or 2007) to another Excel file of the same version?

I have data that is in once Excel file that is being updated often, about every 20 seconds, by way of a DDE link through RS Linx.

Since the data is being update by the link, I was wondering if there was a macro that could copy the data when a Boolean value changed.

For example:

If (part passed test) = True Then

copy cells A1-A6 to "C:\GPD_Oct_2011.xls" and [SpecificSheet(s)WithinthatWorkbook] 'GPD - good part data

Else

copy cells A1-A6 "C:\BPD_Oct_2011.xls" and [SpecificSheet(s)WithinthatWorkbook] ' BPD - bad part data

End If

In every instance I will need the data from one worksheet in one workbook to copy to another workbook where it will be needed to be copied to two different sheets maximum.

For example:

Part 1 is of part type ABC. Part 1 passes the testing and came off of tester 1.

That means the data for that part needs to be copied to the GPD_Oct_2011.xls file, to the ABC sheet and the tester 1 sheet. Both sheets are inside the GPD_Oct_2011.xls file.

Part 2 is of type XYZ. Part 2 does not pass testing and came off of tester 4.

That means the data for that part needs to be copied to the BPD_Oct_2011.xls file, to the XYZ sheet and the tester 4 sheet. Both sheets are inside the BPD_Oct_2011.xls file.

I hope I gave you all enough information to adequately describe my problem.
If you would like more information or the actual excel files\example excel files, just feel free to ask and I will be glad to post whatever extra information you need!

Thanks for your help in advance!