I completely agree with all terms and conditions u r saying
I only mean to say that in csv file can we use the macro to copy & paste?
1)If yes then for this problem we can do the same
2) If No then I have a macro that has pasted the data to csv (slighlty different from this problem)
3)one more thing no doubt it was a csv file i have save that file in csv (If u have a doubt that it was not a csv file or any other xyz file then u can create a csv file and take 1.xls &3.xlsx from the post and run the macro and see the result