Scenario: I have a workbook say W1 which has 6 columns A,B,C,D,E,F. Now, i want to fetch the data for column A and F and write it another workbook say W2. I am working with excel 2003 and Excel Application scope does not support it so I do not want to use it.
Is it possible to achieve in a ’ not so complicated ’ way using workbook activities and data table ? Workbooks are in different folders.