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
If (part passed test) = True Then
copy cells A1-A6 to "C:GPD_Oct_2011.xls" and [SpecificSheet(s)WithinthatWorkbook] 'GPD - good part data
copy cells A1-A6 "C:BPD_Oct_2011.xls" and [SpecificSheet(s)WithinthatWorkbook] ' BPD - bad part data
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.
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.
Thanks for your help in advance!